duplicate numbers

C

Carolina Girl

I have an access database that belongs to someone else and I cannot modify
the join properties is there any way to add a criteria in a queries that I
built to filter out duplicate numbers??? Any help would be great thank you in
advance f or any help…
 
J

Jeff Boyce

Please post the SQL statement of the query you are using now...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

a a r o n . k e m p f

with SQL Server, each owner _CAN_ have their own copy of an object,
and it doesn't take anything except owner.tablename

maybe you want to have a different query than susie-- this is
supported in SQL Server, but in Jet it just adds to bloat and dis-
organization
 
L

Larry Linson

Carolina Girl said:
I have an access database that belongs to someone
else and I cannot modify the join properties is there
any way to add a criteria in a queries that I built to
filter out duplicate numbers??? Any help would be
great thank you in advance f or any help.
Click to expand...

What do you mean "cannot modify the join properties"? If you mean you
cannot change the defined Relationships, that's OK, because you can use a
different Join in your Query than is defined in Relationships without
"modifying the Relationships".

Secondly, what do you mean by "duplicate numbers"? Do you mean duplicate
records in the same table, or corresponding records in two different tables?
In all recent versions of Access, the Query Wizard has had some options that
you might find useful.

Larry Linson
Microsoft Office Access MVP
 
Top