Why Doesn't All Records Show In Report

[Ty Archer]

I have a report based on a parameter query. The query ask
for a start date and end date, and also a supplier name,
account code, budget number, and a requested by person.
However, when I run the report for specific dates and use
wild cards for the other information it does not give me
all records. Only if I go to the query and run put in the
infor on the query design screen I get all records.

Why is it that I get all info on when I run from the query
and not the report? Thanks very much for your help.

 

[Duane Hookom]

Possibly your problem is that wild cards do not match null values. For
instance, if you have a criteria under a ShipToCity of
Like "*"
none of the records with a Null ShipToCity will be returned. If, however,
your column is Ship2City: ShipToCity & "", the "*" will work.