K
Ktowner
I am tracking the service on my equipment fleet with Access. The older
equipment has a 12 month service interval and the newer a 24 month service
interval. In my queries, I am using the <Date()-335 to find the 12 months
service that is within 30 days of being due. I am using a separate query
with the <Date()-700 to find the 24 months service that is within 30 days of
being due. I use a separate field to indicate 12 or 24 month service
interval for a piece of equipment. I am running 2 separate reports with the
2 queries. How can I write one query to show both 12 and 24 month service,
30 days of being due for a single report?
Thanks In Advance
Don K.
equipment has a 12 month service interval and the newer a 24 month service
interval. In my queries, I am using the <Date()-335 to find the 12 months
service that is within 30 days of being due. I am using a separate query
with the <Date()-700 to find the 24 months service that is within 30 days of
being due. I use a separate field to indicate 12 or 24 month service
interval for a piece of equipment. I am running 2 separate reports with the
2 queries. How can I write one query to show both 12 and 24 month service,
30 days of being due for a single report?
Thanks In Advance
Don K.