Query last 7 days

C

CraigADavisJr

HELP!!!

Using Access 2000, I have a field titled "Open (date)", I am trying to
create a query that gives me only records that have been opened in the
last 7 days.

Using Expression Builder I have:
=Date()-"7"
Click to expand...

It returns the records from the last 7 days but it also has a record
from last year. This sounds like it should be easy, but I am teaching
myself on the job. Any help would be greatly appreciated!

Craig
 
C

CraigADavisJr

I entered it without the quotes and they automatically appeared when I
clicked out of the area.
 

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

Word 365 is saving great to Dropbox, but upon rebooting next day, Word does not show the file I last saved. 0
dates in queries 4
Help with last 7 days running total 12
Project Start and End Date is not consistent 1
Finding totals withing a seven day period 9
Working on birthday "book" for my wife and having layout/editing trouble 0
Average last 30 days for each day in the quarter 7
query to show where no data in a stated column 0

Top