Reminders

[bursteffect]

hello everyone



im trying to set up date reminders in my access 2010 program.

im a first aid, cpr trainer and i created a db with the table name (clients) my primary field [clientID]
[name],[employer],[date], and [training hours]. i created a query from my (clients)table, and also
a form from that query. In my query under the date field in the criteria column i use the following
<=Date-330 which means date older than 330 days show. but its not working. i know im doing something
wrong just dont know what. can you please help me...

what i want it to do is to give me a list of the ones that is out dated. datediff syntax or what.

[Bob Fitz]

Try:
<=DateAdd("d",-330,Date())