Results Based upon a Date

  • Thread starter Thread starter Teri
  • Start date Start date
T

Teri

I am constructing a database that reflects shipment
dates. The manager wants to print a report showing

SHIPMENTS BEFORE SHIPPING DATE
Customer:
-1 Day Before Ship Date
-3 Days Before Ship Date
-1 Week Before Ship Date
-1 Month Before Ship Date

For the customer information, I have used
Like [Type CustomerID or hit ENTER for all] & "*"

but I have no idea how to get the other results. Can
someone please help?
 
How about providing about 10-15 records and how your manager would expect to
see them in a report.
 
Back
Top