Combine (concatenate?) in Access~special circumstances
Hi, I need to be able to combine (concatenate?) fields in Access so that each item in Field 1 is joined to each item in Fields 2 thru 5. I have tried to illustrate this in the samples below... In the samples below, Account code is in Field 1... String(s) to be added are in Field 2. Then in Field 3 I need for each code in Field 1 to be joined with all of the strings in Field 2 thru Field 5. Account Code String(s) to be added to each Account Code 001-001001-001234- 401260 001-001001-002345- 401270 001-001001-003456- 401280 001-001001-004567- 750400 001-001001-005678- 410000 001-001001-006789- 420000 002-002001-001234- 430000 002-002001-002345- 440000 002-002001-003456- 450000 002-002001-004567- 460000 002-002001-005678- 002-002001-006789- 002-002001-006543- 002-002001-006432- 002-002001-006321- So I would like to end up with this result: 001-001001-001234-401260 001-001001-001234-401270 001-001001-001234-401280 001-001001-001234-750400 001-001001-001234-410000 ... and on and on until each account code in Field 1 has been combined with every string in Field 2 thru Field 5. Is that possible to accomplish using Access? Thanks, Ken
[!-- / message --] Software/Hardware used:
ASKED:
August 2, 2010 12:28 PM
UPDATED:
August 6, 2010 7:37 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
The method needed would take some time to type in here, so try this link.
This is a good pdf that should help.
It will lead you through it step by step.