query for distinct information

[renartbrazil]

Ok, I am going to botch this I already know but one question here about an Access query.
I query a database using Access. One field is called State, Car and Type. So if I do a query of course there is different info pulled, but I get alot of data. So what I want to know is how could I complete the query to just find the records that shows the Cars only if there is more than one Type in the same State. I can pull the data but narrowing it down to just the record that show more than one type listed but have to have the same State.
I use the Design view, not advanced enough for the other stuff.
The only other thing I can think of to get these results would be to do a huge query and have a macro do it that way so it would not put too much on the server for the DB since many others use it. If anyone has any suggestions or know how to go about this, it would be great!

 

[HitechUser]

renartbrazil ,

Hey an idea. (to help us). Click the SQL view (go ahead you can do it nothing will happen..

Now copy they SQL code and post it here. I think we will better understand your request.

Also we may be able to provide your solution.