Can't figure out how to select dates

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

Guest

I have a database with about 30 clients and 15 different due dates. I want
to set up a query that will let me know when a due date is within 30 days of
the current date. With the criteria that i have now, <Date()+30, access will
give the name of the person that has a due date within the 30 days, but it
gives me all the 15 due dates instead of the one that is due. The program
sees it as that person has met the criteria of haviong a due date within 30
days, so instead of displaying the one due date, it displays all 15 under
their name....Please help me in trying to find out how to get it to just
display what is due. Thanks.
 

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

Queries 1
Countif 3
Excel Excel due and overdue date colours 2
Auto email when due date is due 2
Calculated Date Field 1
Creating an update query that uses multiple parameters 2
SQL Upsizing: Invalid use of "getdate" within a function 4
Target Due date and countdown for working days 1

Back
Top