Home > IT Answers > Database > SQL or VBA code to loop through two columns of data
Limey
5 pts.
 SQL or VBA code to loop through two columns of data
Microsoft Access, VBA
I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product has one to many link product codes that I wish to display in one row instead of the above. I've spent days trying to work this out in Access and Excel but can't do it. Would somebody please help me with this task.

Software/Hardware used:
ASKED: May 19, 2009  12:34 PM
UPDATED: May 20, 2009  8:27 PM
RELATED QUESTIONS
Answer Wiki:
Use VBA recordset sorted by product code, then loop through this recordset making string needed.
Last Wiki Answer Submitted:  May 20, 2009  8:26 pm  by  msi77   1,610 pts.
All Answer Wiki Contributors:  msi77   1,610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _