Creating Query and combining contacts in the same row/column

So I’m trying to figure out how to go about this but all that turns up is just several rows with the top level information for every low level information.

My database has two tables I’m trying to merge into one, which obviously using queries is the best solution but my SQL is shoddy and I’m not entirely familiar with how to setup a query like this.

Table 1 - Customer ID | Company Name | Address Table 2 - Customer Contact Company | Contact Name | Email Address 

So I have all my information filled out, Table 1 and Table 2 is linked via Company Name and Company and I have multiple Contacts listed under each company.

What I’m trying to do is get a query where it shows the ID, Company Name, Contacts associated with that company, the email addresses associated with that contact, and the address of the company.

I’m just not entirely sure how to merge these together so that under one column and in one row to have them all grouped under the company.

I’ve tried using the Query Wizard to create a Duplicates Query but that results in the same thing as not using that query.

I’ve looked online but nothing seems to stick as I’m definitely missing good portions of information.

How do I get all the contacts listed under the same company without having 2 – 10 rows because there are multiple contacts?

I can try to explain better later, right now I need to get the question out there.

submitted by /u/TakeBeyond
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on