I'm a bit of an Access newbie, so bear with me. I have a database
I've created with a query that calculates the date of next service
based on a 60-day rotation. My boss wants me to come up with a query
that he can run to generate a report that will calculate (based on the
previous query), which items will need service within the next 7 days,
or within a specified week range (i.e. he types in the start and end
dates). I'm fuzzy about how the Date(), CDate() and CVDate()
functions work and I'm not sure which to use and how. Any help would
be greatly appreciated.

joshd (AT) abswebb (DOT) net (TechJosh) wrote in message news:<ca9247b9.0310140538.1006339c (AT) posting (DOT) google.com>...
Hello TechJosh,

As a suggestion, open up a new query and use the other one
as your source. Make sure your date field is in the QBE grid
besides all of the required fields.

Next, put the following in the criteria row for the date field:

Date()+7

This will get you records between the current date and 7 day later.

Regards,

Ray

also take a look at datediff()

-john

raycait (AT) excite (DOT) com (Ray) wrote in message news:<20ba9f4a.0310150429.21a098b9 (AT) posting (DOT) google.com>...