Label Report with 2 page setups

[Guest]

I have created an Access Label report which i need to be able to print in
either of 2 layouts. One label sheet has 4 vertical columns of 10 labels and
the other has 2 vertical columns of 10. They are from the same vendor so the
second sheet is dimensioned the same as the first only I print to columns 1
and 3 with 2 & 4 being left blank. I have a y/n datafield which I would like
to use to determine which layout to use - the content on the label is the
same either way. How do I say if condition is 'Y' open report in page setup
1 and if 'N' open with page setup 2. Or is it necessary to have 2 separate
reports?

 

[fredg]

I have created an Access Label report which i need to be able to print in
either of 2 layouts. One label sheet has 4 vertical columns of 10 labels and
the other has 2 vertical columns of 10. They are from the same vendor so the
second sheet is dimensioned the same as the first only I print to columns 1
and 3 with 2 & 4 being left blank. I have a y/n datafield which I would like
to use to determine which layout to use - the content on the label is the
same either way. How do I say if condition is 'Y' open report in page setup
1 and if 'N' open with page setup 2. Or is it necessary to have 2 separate
reports?

I would have 2 separate reports.