Date Calculations

[Sgt Bilkp]

Bit of a Query on a Query!

I have a table (tblTraining) and a field called QualExpiry (short date field). This is date listing when a persons qualification requires renewal (expires). To plan ahead, i want to run a query listing all my staff members courses when the expiry date is only 4 months away, and order the records in ascending order (so those closest to those with greatest time). Any ideas?

 

[raskew]

Set the criteria for your date field to: <= dateadd("m", 4, date()), then sort on that field.

Bob

 

[pbaldy]

You can use the DateAdd function to add 4 months to the current date (Date function) and use that in the criteria.

 

[Sgt Bilkp]

Result!

Cheers