date function Question

[Stingfish]

I want to build a query that will spit out a list of clients where they need to be sent reminders. The query needs to check the ExpireyDat against todays date. The query should spit all the clients where 7 days prior to their expirey date

Do I use something like this e.g
LetterReminders: DateDiff("d",7[ExpireDate])

I will be using this query to run when the DB is opened so that users are remindered who needs to received a letter.

 

[Tim L]

Hello Stingfish!

I would put something like the following in a query to produce the list of clients that you need:

• ExpireDate
  <=Date()+7

Which should return all records that have an expiry date that occurs within the next 7 days, rather than just records that are exactly the 7 day difference, which could mean that some records are missed out if weekend dates are not catered for correctly.

You can then set the query as the recordsource for the form that you open when the db is opened. It would be a good idea to make sure that the form can be closed even if there are no records in the query. You can ensure that controls, such as a close form button, will display by placing them in the Footer or Header area of a form.

Incidentally, I think that you should really have directed this question to the Queries forum rather than the forms one.

Tim

 

[Stingfish]

Thanks Tim!!

my apologies! next time I will direct any queries in the correct forum section