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

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

Processing your response...

Discuss This Question: 1 &nbspReply

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

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

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

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