Data Type Mismatch in criteria expression - adding a third query

[nightwing60]

I added a third query to a query with an outer join and now I get an error message: Data Type Mismatch in criteria expression.
I thought perhaps it was something to do with the 3rd query so to test; I removed one of the queries that was working and kept the new query, and it worked fine. It is only when I add my third query...two queries (does not matter which two queries I keep) it works as it suppose to work.

The SQL is as follow
SELECT [ATT Supplier] & [Test Supplier] & [Verizon Supplier] AS Supplier, Sum([ATT Charge] & [verizon charge] & [test charge]) AS [Supplier Charge], CircuitData.Grouping, CircuitData.cust_name, CircuitData.ptt_bill_refid, CircuitData.[Billing Acct#], CircuitData.Type, CircuitData.ptt_name, CircuitData.orion_order_refid, CircuitData.orig_site_address, CircuitData.citya_name, CircuitData.countrya_name, CircuitData.term_site_address, CircuitData.cityb_name, CircuitData.countryb_name, CircuitData.cct_order_mthly_amt, CircuitData.validation_comments
FROM ((CircuitData LEFT JOIN [CircuitChargeSummary-ATT] ON CircuitData.ptt_bill_refid = [CircuitChargeSummary-ATT].[ATT Circuit]) LEFT JOIN [CircuitChargeSummary-Verizon] ON CircuitData.ptt_bill_refid = [CircuitChargeSummary-Verizon].[Verizon Circuit]) LEFT JOIN [CircuitChargeSummary-TestData] ON CircuitData.ptt_bill_refid = [CircuitChargeSummary-TestData].[Test Circuit]
GROUP BY [ATT Supplier] & [Test Supplier] & [Verizon Supplier], CircuitData.Grouping, CircuitData.cust_name, CircuitData.ptt_bill_refid, CircuitData.[Billing Acct#], CircuitData.Type, CircuitData.ptt_name, CircuitData.orion_order_refid, CircuitData.orig_site_address, CircuitData.citya_name, CircuitData.countrya_name, CircuitData.term_site_address, CircuitData.cityb_name, CircuitData.countryb_name, CircuitData.cct_order_mthly_amt, CircuitData.validation_comments
ORDER BY [ATT Supplier] & [Test Supplier] & [Verizon Supplier];

[pbaldy]

Check that the fields being joined on are of compatible data types. It also seems odd you're using "&" in the Sum(); I'd expect "+".

[ItsMe]

Like Paul said, must be data types. I pasted your SQL in a new qry and was able to get it to work just fine. No errors for me. All data fields I created are text with the exception of the fields in sum.

.