Query Help

  • Thread starter Thread starter Ktowner
  • Start date Start date
K

Ktowner

I am tracking 12 and 24 month wheel bearing service on my equipment fleet
with Access. In my querys, 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. I am
running 2 seperate reports with the 2 queries. How can I write one query to
do show both 12 and 24 month service 30 days out on one report?

Thanks In Advance.

Don K.
 
WHERE [ServiceDate] BETWEEN DateAdd("m", 11, Date) AND DateAdd("yyyy", 1,
Date) OR [ServiceDate] BETWEEN DateAdd("m", 23, Date) AND DateAdd("yyyy", 2,
Date)
 
Back
Top