Query Weekly Data

[Scott]

I have a date field called "transactiondate". How do I query all the data
for the previous two full weeks? How do I query the data for the previous 52
full weeks? Not inclusive of the current week.

 

[Dorian]

Use DateDiff function. Look it up in Access Help.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Duane Hookom]

You can use BETWEEN ... in the criteria under the TransactionDate field. Open
a module and search for Help with Date Functions. You will find the DateAdd()
function which is probably what you need.

Come back if you have additional questions.