R RobFMS Nov 15, 2005 #2 Try creating a query that includes all the fields and use the DISTINCT statement Select Distinct Field1, Field2, .... FieldX From Table1 HTH Rob Mastrostefano -- FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com FMS Advanced Systems Group http://www.fmsasg.com/
Try creating a query that includes all the fields and use the DISTINCT statement Select Distinct Field1, Field2, .... FieldX From Table1 HTH Rob Mastrostefano -- FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com FMS Advanced Systems Group http://www.fmsasg.com/
M [MVP] S.Clark Nov 15, 2005 #3 There is an inherent problem, as you'll need to explain to Access what constitutes a duplicate record, in the form of a WHERE clause.
There is an inherent problem, as you'll need to explain to Access what constitutes a duplicate record, in the form of a WHERE clause.
