Conditional Reporting

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

MikeG

For some of our customers, we are missing their telephone
numbers. We want to have two different reports which we
call our Customer Contact Sheet, containing all of the
information about the customer.

For those customer's whose telephone numbers are missing,
we do NOT want to print the field "Telephone Number", nor
do we want the prompt of "Telephone Number" to appear, so
we've created two different reports.

We want the Macro (or whatever) to print the report
containing the telephone number for those customers whose
tel numbers we have. If the telephone number is missing,
we want the other report to print.

Sorry if this is confusing.

Thanks.

MikeG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top