query to retrive all orders made within the last 7 days (1 Viewer)

[marky_dp]

Hi, I wonder if any one could help me with what I think is a simple query.

I would just like to show all the orders thats have been made within the last 7 days.

So far I can retrieve all the orders made today, by using 'Date()' as my criteria, but cant figure out what criteria to use for the last 7 days. It would also be good, if i could figure out how to retrive all orders made within the last month, and as well select all orders made between two specific dates.

Regards

 

[KenHigg]

>date()-7

???

 

[KeithG]

Ken is write but I think he meant >=Date()-7

 

[KenHigg]

Ken is write but I think he meant >=Date()-7

Is write right?

 

[marky_dp]

Cheers chaps, thats really appreciated

 

[KeithG]

Well I guess we all make mistakes

 

[marky_dp]

Ok, so retrieving the dates for the last 7 days and 30 days is easy enough, but how would you retrive all orders made within the last calendar month?

 

[KenHigg]

I would simply have the user prompted for the date to go back to...

 

[workmad3]

Hmm... I would look at how to split up the Date() into days, months etc. Then once you have that, store the days, then do Date()-days (or possibly Date()-(days-1)

 

[raskew]

Hi -

To return all records from the current month, place this in the criteria cell of your date field:

Between DateSerial(Year(Date()),Month(Date()),1) And Date()

To return all records from month previous to the current month, place this in the criteria cell of your date field:

Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

Added:
Additionally, you might want to take a look at this post http://www.access-programmers.co.uk/forums/showthread.php?t=104911 which provides a method for specifying any mm/yyyy as your query criteria.

HTH - Bob

 

[marky_dp]

Nice one raskew, thanks very much for your help, you've sorted me ouit a treat. Cheers