Solved Query to combine Separate lines within a table (1 Viewer)

[Number11]

Hello,
I need to find a way of having a query show the data within a table on separate Lines (records) for the same Customers on one line

The fields I would need are

Customer_Account (contained in both records)

MAC_Serial_ElectrciityTV (on separate Record lines)

MAC_Serial_ElectrciityPC (on separate Record lines)

looking for results to show on one line like this

Customer_Account MAC_Serial_ElectrciityTV MAC_Serial_ElectrciityPC

 

[Number11]

build separate queries and pulled together using Group By

 

[The_Doc_Man]

I see you answered your own question - using GROUP BY (probably on Customer_Account). That is reasonable.

However, I would like to offer an observation (NOT INTENDED AS A CRITICISM). The structure of these two tables that you mention makes me wonder WHY that information is kept in separate tables but still is dependent on the same key. Normally, that would be considered a violation of normalization. Just observing...

 

[theDBguy]

Just in case it applies here.

Code Snippets

 

[Pat Hartman]

Did you try using a crosstab query? That is the typical way to pivot the many-side data so it appears in one row.