Access Help

thecremeegg

thecremeegg

thecremeegg

Soldato
Joined
13 Oct 2006
Posts
8,152
Location
Surrey
Think this is probably the most relevant section, so here goes:

I've created a query where i want it to show all people that are due to have a reminder sent if they haven't been in for 30 days. I know that I have to put something in criteria but i cant figure out what. I know that i need to do todays date =date() minus the date in the tables and ensure that it only shows values over 30.

Anyone got any ideas (if you have any idea what im talking about?)

Would be greatly appreciated

Cheers
 
I don't know how your query is set out, but this is the syntax that will filter records for just the last 30 days.

Between Date() And DateAdd("d",-30,Date())
 
I put that into the criteria box and obviously changed the date to what i needed and it says that it contains the wrong number of arguments...any ideas?
 
Last edited:
thecremeegg said:
I put that into the criteria box and obviously changed the date to what i needed and it says that it contains the wrong number of arguments...any ideas?
Click to expand...

To specify dates, you need to surround your dates with a # eg:

Between #01/01/2001# and #22/02/2003#.

However, I'm not sure how you would integrate that with my previous example.
 
Create a new column in the query
DayCount=Date()-[LastOnline]

[LastOnline = the name of the field in the table that stores the date - not sure what yours is called]

and then in the criteria of that column put >30
 
You must log in or register to reply here.
Back
Top Bottom