Error creating a report from a query

[Hunter O.]

Hello,

I can run a query but when I try to display this information on a report I get the following message:

The specified field “tblMachineData.TagName’ could refer to more than one table listed in the FROM clause of your SQL Statement.

Here is my SQL code from the quey.

SELECT tblMachineData.TagName, [tblMachineFloat Query].DateAndTime, tblMachineRunTag.TagName, tblMachineFloat.Val
FROM tblMachineRunTag INNER JOIN (tblMachineData INNER JOIN ([tblMachineFloat Query] INNER JOIN tblMachineFloat ON [tblMachineFloat Query].DateAndTime = tblMachineFloat.DateAndTime) ON tblMachineData.TagIndex = [tblMachineFloat Query].TagIndex) ON tblMachineRunTag.TagIndex = tblMachineFloat.TagIndex
WHERE (((tblMachineFloat.TagIndex)=0 Or (tblMachineFloat.TagIndex)=1 Or (tblMachineFloat.TagIndex)=3 Or (tblMachineFloat.TagIndex)=4))
ORDER BY [tblMachineFloat Query].DateAndTime DESC;

Any help is appreciated,
Hunter

 

[Hunter O.]

Problem solved.

 

[andyski101]

Care to share how you did it?

 

[Hunter O.]

I had help from another forum to solve this but I had two fields with the same name in two tables so I had to give an alisa. I need to read up on this to learn more about my problem and how to prevent in the future.

Thanks,
Hunter