Field Date Same in 3 Different Fields

  • Thread starter Thread starter natira
  • Start date Start date
N

natira

Well, that's not a very good description of what I'm trying to do but it's
hard to put this stuff into a few words. I am using MS Access 2003 and am
having a major "brain fart." ;-)

I.E. - I have this table:

Region Class Number Item Number Item Name Price
00170 45682 4500 One 1.00
00170 45682
1.25
00170 45682 6500 Two 1.25
00165 45682 4500 One 1.25
00165 45682
1.25
00165 45682 6500 Two 1.02

I want to pull records where the Region, the Class Number and the Price are
all the same. I.E.:

Region Class Number Item Number Item Name Price
00170 45682
1.25
00170 45682 6500 Two 1.25
00165 45682 4500 One 1.25
00165 45682
1.25

I cannot, for the life of me, figure out how to do this. I'm not having any
trouble building queries with two or more tables but I must have some sort of
mental block on this single table query.

Thanks for your time!
 
Use two queries ---
SELECT natira.Region, natira.[Class Number], natira.Price
FROM natira
GROUP BY natira.Region, natira.[Class Number], natira.Price
HAVING (((Count(natira.Region))>1));

SELECT natira.*
FROM natira INNER JOIN natira_1 ON (natira.Price = natira_1.Price) AND
(natira.[Class Number] = natira_1.[Class Number]) AND (natira.Region =
natira_1.Region);
 
Back
Top