Query Weekly Data

S

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.
 
D

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".
 
D

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.
 
Top