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
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