more than one table error in report mode

[jonesy29847]

I am receiving the following error message when I run a report;



The specified field CustName could refer to more than one table in the FROM clause of your SQL statement.

My SQL statement, which returns the desired results, is as fiollows;

SELECT PrimaryCustomer.ContactFirstName, PrimaryCustomer.ContactLastName, PrimaryCustomer.Phone, PrimaryCustomer.Fax, PrimaryCustomer.VendorID, [Project Expenses].[Expense Date], [Project Expenses].[Expense Description], [Project Expenses].[Expense Code], [Project Expenses].[Expense Amount], SecondaryCustomer.CustJobNumber, Invoice.JobName, PrimaryCustomer.CustName, PrimaryCustomer.StreetAddress, PrimaryCustomer.StateProvince, PrimaryCustomer.City, PrimaryCustomer.ZipPostalCode, PrimaryCustomer.PONumber, PrimaryCustomer.CustJobNumber, SecondaryCustomer.CustName, SecondaryCustomer.CustJobNumber, PrimaryCustomer.Terms
FROM (Invoice INNER JOIN ([Project Expenses] INNER JOIN SecondaryCustomer ON [Project Expenses].JobNo = SecondaryCustomer.JobNo) ON Invoice.JobNo = [Project Expenses].JobNo) INNER JOIN PrimaryCustomer ON Invoice.JobNo = PrimaryCustomer.JobNo
GROUP BY PrimaryCustomer.ContactFirstName, PrimaryCustomer.ContactLastName, PrimaryCustomer.Phone, PrimaryCustomer.Fax, PrimaryCustomer.VendorID, [Project Expenses].[Expense Date], [Project Expenses].[Expense Description], [Project Expenses].[Expense Code], [Project Expenses].[Expense Amount], SecondaryCustomer.CustJobNumber, Invoice.JobName, PrimaryCustomer.CustName, PrimaryCustomer.StreetAddress, PrimaryCustomer.StateProvince, PrimaryCustomer.City, PrimaryCustomer.ZipPostalCode, PrimaryCustomer.PONumber, PrimaryCustomer.CustJobNumber, SecondaryCustomer.CustName, SecondaryCustomer.CustJobNumber, PrimaryCustomer.Terms, [Project Expenses].JobNo
HAVING ((([Project Expenses].[Expense Date]) Between [Forms]![Print Reports].[fmStartDate] And [Forms]![Print Reports].[fmEndDate]) AND (([Project Expenses].JobNo)=[Forms]![Print Reports].[JobNoCombo]))
ORDER BY [Project Expenses].[Expense Date];

The report explicitly uses PrimaryCustomer.CustName and SecondaryCustomer.CustName.

What am I missing?

Thanks

[pbaldy]

If the query returns proper results, it's in the report somewhere. If the field is referenced properly in textboxes, you might look in Sorting and Grouping.

[jonesy29847]

Solved, found it in Text Box, Thanks much!

[pbaldy]

Happy to help.