Creating summary information for labels

[empire]

Dear all,

I need to create labels that summarize text information in a field.

I have a field called catalog number. Then, I have another field called voucher. So I have records with the same catalog number but with many vouchers.

Example:

Catalog no. 345 Voucher:pa-123

Catalog no. 345 Voucher:pa-632

Catalog no. 345 Voucher:pa-388

How can I have a label that shows the catalog number once with all the voucher information summarized. I need to print one label per Catalog number with all the voucher info.

The final result should be something like this:

Catalog no. 345 Voucher:pa-123

Voucher:pa-632

Voucher:pa-388

All the info in one label.

I hope this makes sense.

Thanks a lot in advance for your help.

[Brian C]

Create an unstored calculation field at the Catalog TO.

Use the List() function to grab each of the values for the related voucher. You can then make use of the substitute() function if you want to filter out the pilcrows (carriage returns).