Show Multiple Values on one row

C

cp2599

I have a phone table with multiple records for one individual. I want
to show all the phone types and numbers for an individual on one row.
How do I get them to appear on one row with the Individual Name?

Phone Table:
PhoneID
IndID
PhoneType
PhoneNo

Ind Table:
IndID
IndName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Weekly Report 2
displaying multiple data types 2
Primary and Foreign Keys 10
SELECT MAX(value) from table1 and add several associated values from table2 10
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Query to select individual records 4
Need help to incorporate procedural cursor logic into Access Form 0

Top