Predefined date range

G

Gonzalo

I created a query with a date field, I want the query to give me all records
with a date of Sunday (1) to date()
 
R

raskew via AccessMonster.com

Hi -
Place this in the criteria cell of your date field:
=Date()-Weekday(Date())+1 And <Date()+1
Click to expand...

Using this format rather than the Between mode allows for times if in fact
your date field includes both date and time.

HTH - Bob
 
G

Gonzalo

Thanks again for the help, I have a question can add to the statement, If I
run the query on a Monday to give me all records of the previous week, since
I haven't entered any data for the current week.
 
Top