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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date query Criteria 4
Using Between...And with General Date 2
Dcount returning no results!!! 0
Query for 1st field, if blank then query 2nd field but not both. 6
#error - Blank 3
Query using date range entered by user 2
query based on date ? 1
How to write a query that add 1 working day to the date 2

Top