New Orders in last 30 days on reports

  • Thread starter Thread starter Guest
  • Start date Start date
BetsyK said:
How do I get a total of all new orders in the last 30 days?
Click to expand...

Create a "Totals" query that delivers one record for each
order, with the sum for each Order, Use a criteria of Order
Dates within 30 days...
OrderDate >= DateDiff("d",-30,Date())
Place those records in the Detail Section, and sum in the
Report Footer.
hth
Al Camp
 
Back
Top