Duplicate Entries in Report

[jstoto]

Below is my SQL statement for a report I have. I added the DISTINCT so that when it finds a duplicate entrie but it still does not work. Can someone help with this PLEASE.

SELECT DISTINCT [tblEnduser].[EU_EID], [tblEnduser].[EU_NAME], [tblEnduser].[EU_Phone], [tblEnduser].[tblroom], [tblAsset].[AssetSN], [tblAsset].[AssetManu], [tblAsset].[AssetModel]
FROM tblEnduser INNER JOIN tblAsset ON [tblEnduser].[EU_EID]=[tblAsset].[OwnerEID]
ORDER BY [tblEnduser].[EU_NAME];

Thank you for all help

 

[randysmid]

Hi,
I have reviewed your SQL statement, and it looks correct. So, is it possible that you have duplicate records inside your tables???
HTH,
Randy Smith
California Teachers Association

 

[CosmoKramer]

Instead of DISTINCT, try the DISTINCTROW predicate.

 

[jstoto]

distinctrow did not work but I do have multiple entrioes in teh table. After looking at the report I have decided to hide multiples but not all fields. thank you for all the help