Link to home
Start Free TrialLog in
Avatar of Jose C
Jose CFlag for United States of America

asked on

query to create labels from table records that contain multiple lines

i have an access table called QB_ItemNonInventory
within the table is a column called SaleorPurchaseDesc
records within this column contain carriage returns

i want to create a query that i can then use for a mailmerge (or report) that will put each record on a separate label, including the carriage return.

i've tried parsing the record our based on the carriage return chr(13) but that doesn't work on these records.

attached is a sample in access 2007 format and any help is appreciated.

example of what i'm trying to accomplish

source record:  
6" Surface Unit Element SU201 660532 [cr]CMS #801025[cr]HD Supply #233000

result:
[line1]  6" Surface Unit Element SU201 660532
[line2]  CMS #801025
[line3]  HD Supply #233000
expertscarriagereturntest.accdb
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jose C

ASKER

will have to revisit this later but thanks for the input..