I have a access table and want to find dup lines

Alan · Jul 24, 2005

Hi!

I have an access table and I want to find duplicated lines in this
table.

If one can suggest a solution? I'm not really experienced in
programming...

Thank you!

P.S.
I've found a stand alone freeware for finding duplicated lines
(http://www.aks-labs.com/support/phpBB2/viewtopic.php?t=69) , but I
think I need something within access

M.L. Sco Scofield · Jul 25, 2005

Alan, please excuse my sarcasm, but have you spent *any* time looking at
Access?

Granted, using help is pretty much useless, however...

Select the query objects and click new. Out of the five options, the fourth
is the "Find Duplicates Query Wizard".

Just answer the wizard questions. No coding. No programming. It doesn't get
much easier.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

I have a access table and want to find dup lines

Alan

M.L. Sco Scofield