Looking back several days

  • Thread starter Thread starter fred w
  • Start date Start date
F

fred w

Hello

I think I am having a senior moment here - I should know
this! Anyway, I need to query back several days from
today.

Thank you for your help!
 
Ah, we all have moments...

WHERE MyDate >= (Date() - n)

... where n is the number of days back you want to go.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 

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

Update Query using Table & Query 3
New member of the family 3
One query to multiple databases 7
Excel Formula - Count Dates from another Sheet 8
Calculating seniority 4
Looking for date field that is empty 7
Cumulative Sum 4
Computer Nooby , advice needed. 1

Back
Top