Neil_Pattison
Registered User.
- Local time
- Today, 23:23
- Joined
- Aug 24, 2005
- Messages
- 73
I have a table that holds the info on our fleet of company vehicles. One of the fields in the table is called ServiceDueDate. I want to be able to set up a query that shows any vehicles that have a service due in the next 30 days.
I know I'll need to use DLookup in there as well as Date - 30 but not sure exactly how to write the query.
Any help would be greatly appreciated.
I know I'll need to use DLookup in there as well as Date - 30 but not sure exactly how to write the query.
Any help would be greatly appreciated.