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)
 
You must log in or register to reply here.

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

Similar Threads

select record value in a report 2
Setting up a report for a DYMO labeller 1
Page Setup with VBA 1
Any way to force multiple details on a label? 1
control on form from report 2
MS Access 2007 Dot Matrix Label Printing 0
Only need 1 label to print on label 4 of 6... 7
Show Label & Text Box in Report based on Checkbox 3

Back
Top