Ask Experts Questions for FREE Help !
Ask
    sweetharas's Avatar
    sweetharas Posts: 10, Reputation: 2
    New Member
    		  
    #1

    Apr 30, 2011, 03:00 PM
    Concatenate fields from multiple records
    Is there a way I can use a query combine all the names into a single "virtual" field, so that I only have one row for each address?

    Here is what I would like to see!
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Apr 30, 2011, 03:52 PM

    First its not a good idea to piggyback your question on someone else's. This can lead to confusion. You should start a new thread. So I've moved your question to its own thread.

    Yes you can do this. The function found here Access Help and How-to - Microsoft Office Code To Concatenate Multiple Records Into A Single Field - UtterAccess Discussion Forums will combine fields from multiple records in a group into one column of a query.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

403 Error on multiple sites, multiple PC's [ 1 Answers ]

Any ideas? They aren't denied access to these sites as they are carrier sites. I'm researching as the IT Diector as asked but I figured I'd post on here for some info too.

Merge cells in multiple fields in excel [ 2 Answers ]

How to merge multiple cell in excel file

Multiple baseboards with multiple thermostats one circuit [ 22 Answers ]

Hi again guys, I want to run multiple baseboard heaters one one circuit in my basement. I have a small basement, so I figure I will need about 4 total baseboards. I figure I'll need about 4000 watts, I'm running 240 volt. So according to my code where I live, I'll require #12 and a 30 amp breaker...

Multiple Records in one Field [ 2 Answers ]

HI! I would like to save up to 5 records in one field. What is the best way to do so?

View more questions Search