Access 2003 Query

F

Fesada

Hello: I need to run a query able to find duplicated data within some field.
I tried filters but my DBase is too large and this task became time
consuming. How this expression looks like.

Thanks

hernan
 
D

Duane Hookom

SELECT [Some Field], Count(*) as NumOf
FROM [too large]
GROUP BY [Some Field]
HAVING Count(*)>1;
 
F

Fesada

Hi Duane:

I wrote this query in the criteria field using the expression builder,
however access displays a message saying " The syntax of the subquery in this
expression is incorrect. Check the subquery's sintax and enclose it in
parentheses.

The field I need to check is named TAG. I replaced this name with the one
you gave me: SOME FIELD.

Thanks.

Hernan

Duane Hookom said:
SELECT [Some Field], Count(*) as NumOf
FROM [too large]
GROUP BY [Some Field]
HAVING Count(*)>1;
--
Duane Hookom
Microsoft Access MVP


Fesada said:
Hello: I need to run a query able to find duplicated data within some field.
I tried filters but my DBase is too large and this task became time
consuming. How this expression looks like.

Thanks

hernan
Click to expand...
Click to expand...
 
J

John Spencer

IF you are trying to find duplicate records based on the tag field.

Field: Tag
Order By: Ascending
Criteria: In (SELECT [Tag] FROM [Name of Your Table] GROUP BY [Tag] HAVING
Count(*) > 1)



--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Fesada said:
Hi Duane:

I wrote this query in the criteria field using the expression builder,
however access displays a message saying " The syntax of the subquery in
this
expression is incorrect. Check the subquery's sintax and enclose it in
parentheses.

The field I need to check is named TAG. I replaced this name with the one
you gave me: SOME FIELD.

Thanks.

Hernan

Duane Hookom said:
SELECT [Some Field], Count(*) as NumOf
FROM [too large]
GROUP BY [Some Field]
HAVING Count(*)>1;
--
Duane Hookom
Microsoft Access MVP


Fesada said:
Hello: I need to run a query able to find duplicated data within some
field.
I tried filters but my DBase is too large and this task became time
consuming. How this expression looks like.

Thanks

hernan
Click to expand...
Click to expand...
Click to expand...
 
Top