MS Access 2003 - Query ?

E

Eric Smith

I have created a query to substract the StartDate and EndDate for funding project:

SELECT Avg(DateDiff("d",[StartDate],[EndDate])) AS [Average Days In Pipe]
FROM tblFundingProject
WHERE (((tblFundingProject.ActiveStatus)="Active"));

Works fine. Heres the issue I am trying to figure out. Some of the funding projects do not have a value for the end, because they are still in progress. In these cases I want to use the current date to determine the number of days from StartDate to EndDate. Any thoughts about how to do this?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access query to get monthly and quarterly report 3
Problems with MS Access reading dates as US, not British formats. 2
Crosstab Query Questions 5
Update for Outlook 2003 Junk Email Filter (KB925254) 1
MS-Access sum problem in query 2
delete links from the resource view in Project webaccess 2003 1
Consecutive Date Query 1
Access message "can't find field" 1

Top