three or more

[Guest_imported]

Table: Streeta, Streetb, trouble, atime, class
I have a table which I would like to have a querry which only shows the records if there are three or more in which streeta and streetb match
streeta streetb trouble
ie. main cross flash
main cross green out
main cross stuck
main side flash
main side red out
main side all out

 

[DMac]

Select StreetA, StreetB
from tblMain
Group by StreetA, StreetB
Having Count(*) > 2

Derek Macrae [sig][/sig]

 

[Guest_imported]

Thanks for the help. My mistake was

select Streeta,streetb, trouble
from tbmain
Group by Streeta,Streetb
Having count(*)>2;

which gave me an error
I now use this querry with the tbmain to get a complete listing of 3 or more calls