August 12, 200718 yr Newbies 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.
August 13, 200718 yr 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).
Create an account or sign in to comment