Report problem

[SMERTZ]

I have a report I liked the format of. It reports on a 2 table {Cust}
{Orders} It basically prints one order per page that are of a STATUS
"Open".

I copied the report and changed the data source to a query that asks for a
Order number. This way I can print a single order. When I run the query it
runs fine, asks for an order number and completes when it is typed in.

When I run the report based on that query, it asks for an order number, then
it asks for a customer number, and I'm not sure why it needs a customer
number when the Query does not?

Any thoughts on this?
Access 2002
Thanks

 

[Guest]

The customer number must be the name of a field used on the report or used in
the sorting and grouping of the report that does not exist in the query.
Check your field names in the report.