urgent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIRA - 15 Nov 2005 22:26 GMT

each two row in my table is duplicate ,how to take out duplicate rows?

Reply to this Message

RobFMS - 15 Nov 2005 22:42 GMT

Try creating a query that includes all the fields and use the DISTINCT
statement

Select Distinct Field1, Field2, .... FieldX
From Table1

HTH

Rob Mastrostefano

Signature

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/

> each two row in my table is duplicate ,how to take out duplicate rows?

Reply to this Message

[MVP] S.Clark - 15 Nov 2005 22:51 GMT

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.

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

> each two row in my table is duplicate ,how to take out duplicate rows?

Reply to this Message