G Gonzalo Dec 5, 2007 #1 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()
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 Dec 5, 2007 #2 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
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 Dec 6, 2007 #4 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.
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.