Creating a Query

[ErbeerichR]

I am trying to create a Data Base and Query to help keep track of clients who need to be contacted after their first contact. This re-contact should not happen until at least 7 days after the initial contact.

I want the query to sort them by the initial contact date (which I have no problem doing) but only pull list the clients who's 'hold date' is more than 7 days old, based on the current date. IE, when I open the query, it automatically pulls up the data.

Thanks for any assistance.

[Villeroy]

Just like with any other database:

Code: Select all

SELECT * FROM "Clients" WHERE DATEDIFF('dd',"Date",CURRENT_DATE)>=7;