C
Cheryl-MO
I'm having difficulty figuring out how to write criteria
to select records in the following query. Any help would
be appreciated:
I have a vehicle maintenance database, and I have a query
that currently includes the following: date of
maintenance, odometer reading at maintenance, type
(description) of maintenance, next scheduled mileage for
maintenance, next scheduled date of maintenance, and the
most recent odometer reading for that vehicle.
The "2 next scheduled" columns are calculated from
information from a lookup table tied to the maintenance
description field. These fields add x number of miles and
x number of days to the odometer and day the maintenance
was last performed. The most recent odometer reading is
the maximum number by found for each vehicle in a linked
Excel table. The number format in the Excel spreadsheet
is "general".
What I would like to do is set criteria to only return
those records where the date and/or mileage exceeds either
today's date (or a given date) or where the next scheduled
mileage is higher than the most recent odometer reading.
Please let me know how I can do this, or if you need more
information. thnaks!
to select records in the following query. Any help would
be appreciated:
I have a vehicle maintenance database, and I have a query
that currently includes the following: date of
maintenance, odometer reading at maintenance, type
(description) of maintenance, next scheduled mileage for
maintenance, next scheduled date of maintenance, and the
most recent odometer reading for that vehicle.
The "2 next scheduled" columns are calculated from
information from a lookup table tied to the maintenance
description field. These fields add x number of miles and
x number of days to the odometer and day the maintenance
was last performed. The most recent odometer reading is
the maximum number by found for each vehicle in a linked
Excel table. The number format in the Excel spreadsheet
is "general".
What I would like to do is set criteria to only return
those records where the date and/or mileage exceeds either
today's date (or a given date) or where the next scheduled
mileage is higher than the most recent odometer reading.
Please let me know how I can do this, or if you need more
information. thnaks!