A more clear discription

[DANIELWOODENTOP]

Try this one

Sorry my last post was not very clear.

I have a table with a (date of last purchase) field.
I want to create a query to display the people that have not paid anything in the last 60 days.

I tride using the date() function but could not work out the correct criteria.
Please help me.

 

[pcs]

don't want to be harsh...but, you have double-posted.

just post a reply to your original message.

you have an additional question at:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30992

we are here to help...

al