Why Doesn't All Records Show In Report

  • Thread starter Thread starter Ty Archer
  • Start date Start date
T

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.
 
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.
 
Back
Top