Find Diffrent Values in Table with same id (1 Viewer)

ootkhopdi

Registered User.
Local time
Today, 07:37
Joined
Oct 17, 2013
Messages
181
Hi,


i have a table with 15 fields. In this table there are two fields


ID value
1 A
1 B
2 C
3 D
2 A
2 B
4 A
5 A



Now i want to select Ids which having more than two distinct values


ID Value
1 A
1 B
2 A
2 B
2 C


how can i create query for this..
 

NauticalGent

Ignore List Poster Boy
Local time
Yesterday, 22:07
Joined
Apr 27, 2015
Messages
6,286
To answer your immediate question, use the “Find Duplicates” query wizard using your ID field as the criteria. Easy day...

That being said, if you want to avoid this, your ID field should be an Autonumber/ Primary Key field to prevent this from happening.
 

Users who are viewing this thread

Top Bottom