Results 1 to 2 of 2
Thread: show dates remaining (2003 sp2)
2007-07-27, 19:33 #1
- Join Date
- Jan 2004
- Thanked 0 Times in 0 Posts
show dates remaining (2003 sp2)
I have a query, qryRemainingCalDaysByJob, its fields are: JobNumber, JobName, RemainingWDs, Today, RemainingCalDays.
What I need to do is list in another query, the JobName and dates remaining, including today.
RemainingCalDays=3.69 (round to 4)
I would like to be able to show all the jobs in this query this way, which has 12 jobs.
2007-07-27, 20:05 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: show dates remaining (2003 sp2)
You'd need to create a table with a single field TheDate of type Date/Time.
Populate this table with all dates from (for example) January 1, 2007 until December 31, 2008.
The easiest way to do this is to fill a series of dates in Excel and to copy/paste the dates into the Access table.
Now create a query based on this table and on qryRemainingCalDaysByJob.
Don't join the tables.
Add JobNumber from qryRemainingCalDaysByJob and TheDate from the table to the query grid.
Set the criteria for TheDate to
>=[Today] And <[Today]+[RemainingDays]