Combine (concatenate?) in Access~special circumstances

5 pts.
Tags:
Access
Access Controls
Access Functions
String name
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 --]

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following