Choosing a report based on the output of the query

  • Thread starter Thread starter MikeG
  • Start date Start date
M

MikeG

Is it possible to run one query, and based on the results
of that query, have one of two different reports printed?

For example, let's say that I run the query and I have
several records that are missing the customer's telephone
number. I don't want to see blank fields for those
customer's whose telephone numbers we don't have. I just
want to print a different Customer report (which won't
have the telephone number field) for those customers who
did not provide their telephone number.

For those customers whose telephone number we have, I want
a different report (containing the telephone number field
field) to print.

Sorry if this is confusing.

Mike
 
Hi Mike.
What about making one report and a subreport, one for the
telephone number listing and the other for the address
listing.
Hope this helps.
Fons
 
Back
Top