How to filter data in a report.

[Guest]

I have modified the order entry database template. I'm trying to filter out
orders that have already been shipped in a report. My report is from a
select query with the contacts first and last name, ship date, and customer
Id. What I'm trying to accomplish is to have the report print only the
orders that have not shipped. Currently the report prints all the orders and
thier ship dates if they have one.

Any help would be much appreciated. If you need more information just let
me know.

 

[Allen Browne]

Define "not shipped".

If you mean those orders where the ShipDate field is Null or after today,
the Click event procedure of the command button that opens Report1 would
look like this:

Dim strWhere As String
strWhere = "([ShipDate] Is Null) OR ([ShipDate] > Date())"
DoCmd.OpenReport "Report1", acViewPreview, , strWhere