Query to find all records after a certain date

[Matt Parsons]

Hello all,



Apologies if this query seems too simplistic, I am completely new to Access and have no one to ask!

I have created a database with customers who have accounts with us, and a date field that is the due date to follow up with re-registration. For example, a customer buys a product on a certain date (say 02/07/2011) that lasts a year, the follow up date is then automatically calculated at one year after (02/07/2012). I would like to create a query that shows all customers that the follow up date has now expired. Unfortunately I have no knowledge of the syntax required and have tried the expression builder to no avail.

I have tried to find solutions on the net and on this forum, it seems like there are no solutions for something this simple!

Please help!

Matt

[rpeare]

if your end date is stored in your computer you just have to have a criteria on that field that is


<= date() (less than or equal to today's date)

And it should list all of the clients with expired product.

If your end date is not stored you would have to do something like this in your purchase date field criteria

<= dateadd("y",-1, date())

this basically subtracts a year from the current date and compares it to the purchase date, if the purchase date is less than today's date minus a year it's out of date, if the purchase date is greater than today's date minus a year then it's still valid.

[Matt Parsons]

Many thanks, that's actually solved 2 problems - bonus! How do I mark this thread as solved?

Edit - not to worry, found it!