Mailing Labels Selecting only every OTHER address

[MJC8892]

I'm trying to make mailing labels from an access database using a subset of the zip codes. That, I can do through the Select Expert. Within those zip codes, I need to select every OTHER address. I'm at a loss!!!

 

[dgillz]

Create a running total field that counts the records. Then right click on the details section of the report, and select format section. To the right of the Suppress checkbox is a button labeled X-2. This is the conditional format area. Hit that button and enter a formula

Remainder({#countfield},2)=0

This will suppress all "even" records. Alter the formula to get the odd ones, or maybe tie in a paramter even/odd? field and put the proper logic in the same area, conditionally suppressing the records as you see fit.

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[mbarron]

If you are using mulpitple detail bands, you can conditionally suppress them using:

remainder(recordnumber,2)=0 //shows only odd numbered records

You will need to add the conditional suppression to each band. Mike

 

[mbarron]

Addendum to dgillz (and mine):

Have the running total re-set on the change of your ZIP group. And suppress using:
Remainder({#countfield},2)=0.

By suppressing the even numbers, you will have at least one record for each zip group. If you suppressed using Remainder({#countfield},2)=1, and if there was only one record in that zip, you would end up with a group with no members. This is also why the running total idea is better than the method I suggested. The same empty group would result if there was only one record for that zip, and that record was suppressed.
Mike