Quote:
|
Originally Posted by pete61uk
Hi All,
I need an Access2K query (Table[OrderDate]) to veiw reports going back a 'week' (7 days) based on (and including) the user-defined date.
I've been trying to get it going for hours without any success. Can anyone help?
|
Okay, you want to do something like this, right?
SELECT * from TABLE where ((Table.OrderDate) Between (selectedDate) And (selectedDate - 7))
In "Design View" for the query you would have in the "Criteria" section
Is Not Null And Between [BeginningDate] And [EndingDate]
It's been a while since I created SQL queries in Access. I don't recall exactly how Access does computations with fields of type
Date. Is this for a web-connected database?