Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate Entries in Report

Status
Not open for further replies.

jstoto

IS-IT--Management
May 7, 2002
4
US
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top