troubleshooting Question

Access Query to retrieve info as One record

Avatar of wlwebb
wlwebbFlag for United States of America asked on
Microsoft Access
17 Comments2 Solutions417 ViewsLast Modified:
Hello all,
Don't know if there's any way to do this but I'll ask anyway.  If I have a table containing a text field, is there a way to create a query that summarizes all of those names into one record.

Say my table has

ID (autonumber)
RecTypeID (Number - Index from a table of Record Types)
RecName - Text

Now then I know I can pull a list of all Name fields with RecTypeID 1 or 2 or 3 etc.... BUT
that will give me a list.  Is there then a way to get all of those names as one temporary record within a query?

So let's say I have

ID    RecTypeID   RecName
1           5              Joe Smith
2            3             Jenny Jones
3            1             Mark Doe
4             5             Alvin Chip
5             5             Mary Wright
6             3             Elmer Fudd
7             5            Zack Tway
8             1             Mildred Way

So can I get all the RecTypeID 5's let's say into one query record that would be
Joe Smith, Alvin Chip, Mary Wright, Zack Tway
Join our community to see this answer!
Unlock 2 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros