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