Query??

[Fi64]

Hi,

I've been looking around the forum and it has so much great advice.. I would try to answer some but feel a little out of my depth! I hope some kind soul will feel able to help me with the following

I have to create a database that flags via email, prior to a due date, on a due date and 7 days after the due date has passed. I have calculated the date field in a form from a query that adds 7 days to the date of issue, but am at a loss as to the next step. I think that i need to add criteria to the query field that does the calculation but having tried several different functions, am failing miserably! Can anyone shed a little light on the direction i need to go please? I have worked out that I need to use a hyperlink for the email part.. I just can't work out how to make the database flag specific dates!

Thanks in advance

Fi

 

[Michael J Ross]

Hi,

If I'm reading you right you want a query to select records that fall either a certain number of days before the due date, on the due date or 7 days after the due date.

You can use the following criteria under your due date field

Date()
or Date()-7
or Date()+7

This will pick those records with a due date of current date, or those with a due date of 7 days before current date, or or those with a due date of 7 days after the current date.

Hope this helps

 

[Fi64]

Hi,

Thanks for that .. I had the date + or - ok .. it was how to create the email .. but I have it now having created a macro using 'sendobject'

Thank you for your reply

Fi