1stTimeOut
Technical User
From my database, I output to an Excel spreadsheet. The database shows two records, with some matching fields and some varying fields. I need Access to analyze the LABEL #s and if they match, combine the two records into one row of cells in Excel. I ran a macro using "ALT-Enter" to create a second line in a cell, and the code used was R1C1 and Chr(10).
This is what I have now: 2 rows in Excel
Qty[tab]MKT[tab]LABEL #[tab]CENTER[tab]SEQUENCE #[tab] Date 1
7[tab]ATL[tab][tab]abc-abc[tab]SANTA[tab][tab]3,4,5,6,7,8,9[tab]11/9/2006
7[tab]ATL[tab][tab]abc-abc[tab]SANTA[tab][tab]0,1,2[tab][tab][tab][tab]8/30/2006
This is what I need: 1 row with two lines in a cell if needed
Qty[tab]MKT[tab]LABEL #[tab]CENTER[tab]SEQUENCE #[tab]Date 1
7[tab]ATL[tab]abc-abc[tab]SANTA[tab]3,4,5,6,7,8,9[tab]11/9/2006
[tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab]0,1,2[tab]8/30/2006
Does this make any sense to you all?
Any help is GREATLY appreciated!
This is what I have now: 2 rows in Excel
Qty[tab]MKT[tab]LABEL #[tab]CENTER[tab]SEQUENCE #[tab] Date 1
7[tab]ATL[tab][tab]abc-abc[tab]SANTA[tab][tab]3,4,5,6,7,8,9[tab]11/9/2006
7[tab]ATL[tab][tab]abc-abc[tab]SANTA[tab][tab]0,1,2[tab][tab][tab][tab]8/30/2006
This is what I need: 1 row with two lines in a cell if needed
Qty[tab]MKT[tab]LABEL #[tab]CENTER[tab]SEQUENCE #[tab]Date 1
7[tab]ATL[tab]abc-abc[tab]SANTA[tab]3,4,5,6,7,8,9[tab]11/9/2006
[tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab][tab]0,1,2[tab]8/30/2006
Does this make any sense to you all?
Any help is GREATLY appreciated!