Help with Access Needed

[lilygtg]

I guess this is a two part problem, I haven't used access in a long time and cannot remember anything.



I have a training database and what to be able to automatically e-mail people if they are within 90 days of their expiration date.

Someone told me to use DateDiff but am not getting anything back from the query. Here are some of the examples someone told me to use and I am not getting anything:

Datediff("d",Date(),[expiration date])=>83,<90
datediff("d),Now(),[expiration date])=(between 83 and 90)

(I don't want to continue e-mailing the same people every week so I need to be able to have the people e-mailed the week before drop off the query)

Lastly what do I need to do to automatically e-mail both the person and the supervisor? (Both e-mail addresses are stored in the database).

Thanks so much, any help would be greatly appreciated

[rpeare]

What I would do is build a query that has a list of all people that are due to expire. In your query you'd have a field that was

DaysUntilDue: datediff("d", date(), [Expiration Date])

in the criteria of that calculated field have

between 83 and 90

that should limit it to the people that are between 83 and 90 days of being due

From there you can build your procedure to send out the email and as long as you are storing the different emails then yes, you can send an email to both the person and their supervisor, you can even just BCC (blind carbon copy) their supervisor.

[lilygtg]

Thank you so much the query worked perfectly! Could you please tell me where I start with building a procedure for the e-mail? Thanks again.

[rpeare]

What's the structure of your tables?