Labels

  • Thread starter Thread starter Tori
  • Start date Start date
T

Tori

Not sure if this can be done or not, but I have a query
that pulls up all records that have a check mark in either
Label 1 field or Label 2 field. Label 1 and Label 2 are
two different labels report. Label two is exactly the
same as label 1 only has the word "STAT FILE" on it. The
majority of my labels are label#1. Is there a way that I
can make my report recognize the label#2 and print them in
the same report (by using an If statement?)or do I have to
continue running two separate reports?

Thanks,
Tor
 
Tori said:
Not sure if this can be done or not, but I have a query
that pulls up all records that have a check mark in either
Label 1 field or Label 2 field. Label 1 and Label 2 are
two different labels report. Label two is exactly the
same as label 1 only has the word "STAT FILE" on it. The
majority of my labels are label#1. Is there a way that I
can make my report recognize the label#2 and print them in
the same report (by using an If statement?)or do I have to
continue running two separate reports?
Click to expand...


Easy to do in one report. Use a text box with the
expression:

=IIf([Label2], "STAT FILE", Null)
 
Back
Top