Results Based upon a Date

[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?

 

[Duane Hookom]

How about providing about 10-15 records and how your manager would expect to
see them in a report.