Formatting a report to lose information 1

[bpifer23]

A little backround: I have a main table that has 30 fields. Now I need to make a report that shows all 30 fields, but here's is the kicker: One of the fields is "Actual ship date". What is needed is for this report to show all 30 fields but once "actual ship date" has a date inserted in it, the whole line needs to be removed from the report. Any insight would be great. Thanks!!!

 

[thecreator]

Try basing your report (your record source) on a query and not on the table itself.

For example

Select * from MyTable where Shipdate is null

You will only get the ones in your report that have no date then.