Query Weekly Data

  • Thread starter Thread starter Scott
  • Start date Start date
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.
 
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".
 
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.
 
Back
Top