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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum one field if another field is equal to something 10
A server error occurred 0
Access Default Microsoft Access Order Entry database issue 0
News UK's first 5G service launching on 30 May 3
Showing records based on status 4
Attendance tracker last 30 days 1
Group Totals in Report 7
Grouping by Dates before & after Today's date 1

Back
Top