Help on Calendar Issue

  • Thread starter Thread starter ernestb08
  • Start date Start date
E

ernestb08

I've created a database that will manage the vehicle fleet of a company.
I've worked with everthing, Tables, Forms, Queries and reports.

Now I want the database that will let met know that a registration tag and/or
inspections sticker is due within 30 days prioir to its date.

Thanks.

Ernie
 
If you have set dates when inspection is due and/or registration tag date you
can make a queryusing the Between & And adding these in their criteria boxes
inside brackets. Example: Between [Start Date] And [Inspection Due Date]

2 small windows will prompt you to type the start date 30 days from now and
an inspection due date (or what ever you type inside the parenthesis) 1 day
(date) later, etc.

Maybe someone can make this simpler.
 

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

Back
Top