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)
 
Back
Top