Volume Queries Between 7day ago and now.

  • Thread starter Thread starter Sunamon
  • Start date Start date
S

Sunamon

Guest
Hi All, first of all I must apologize, for I am a newbie to access design...
Now with that taken care of here we go... I have a database which is a work order database, and I'm currently trying to design a query which will return the work orders completed in the last 7 days. But I have been unable to discover how to acomplish this. Please help! Thank you all in advance.
 
Never mind it seems to be gone now...
 
Sunamon-

Maybe dateadd() function be helpful here. Try something like:

SELECT tblPurchases.purchaseID, tblPurchases.Datex
FROM tblPurchases
WHERE (((tblPurchases.Datex)>=DateAdd("d",now(),-7)));

This give you everything during past week.
 
Ok thanks I'll try that. Also I was wondering what will happen on, say the 4th day of a month and you subtract 7 from the day. Will it return a negative day? or will it role over? or will access account for adjusting the month and day... or year for that matter?
 

Users who are viewing this thread

Back
Top Bottom