Special Criteria using the Date Field

M

Mark

Hello,

I created a warranty program using Access 97 and I need
help on one of my queries. I want to be able to look up
products that were returned during a particular month. I
can do that with no problems. However, I would like to
automatically subtract 18 months from the month that
product was returned so I can tell if it is within the
warranty period. I can manually get it to work but it is
a pain to do. Can anyone help. I would appreciate any
comments.

Thanks!
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top