Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database for clients with 15 different due dates. I set up the code
<Date()+30 for Access to notify me with anyone with a due date in 30 days.
My problem is that the program will show me all the due dates because it has
met the one criteria of having on due date within the 30 days. I only want
to see what is due. Thanks for your help......
 
I hope I understand your problem, if not forgive my post.

In the criteria try

Between Date() And Date()+30
 

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

Similar Threads

Can't figure out how to select dates 1
Countif 3
Creating an update query that uses multiple parameters 2
Excel Excel due and overdue date colours 2
Auto email when due date is due 2
SQL Upsizing: Invalid use of "getdate" within a function 4
Due within 2 months report 2
Due data control in form 3

Back
Top