How can I query only records that have multiple associated records

[TraciAnnNeedsHelp]

I have a table of Customers who has Equipment assigned to them. I need to run
a quick query that will show only customers (of a certain type) who has more
than piece of Equipment assigned.

I am using a Customers table with a TypeID and an Equipment table with a
one-to-many relationship on the CustomerID .

The query needs to show Only CustomerID's from the Customer's table with a
TypeID of "5" who have more than 1 associated EquipmentID in the Equipment
table.

I know it's simple but all I get are ALL Customers with Equipment.

Thanks in advance!

 

[TraciAnnNeedsHelp]

Please forget I ever asked. This was so simple. I had a morning brain freeze.

I totalled on the EquipmentID field using "Count" and set a parameter of ">1".

So sorry!
TraciAnn Needs Coffee

 

[Clif McIrvin]

Please forget I ever asked. This was so simple. I had a morning brain
freeze.

I totalled on the EquipmentID field using "Count" and set a parameter
of ">1".

So sorry!
TraciAnn Needs Coffee

Been there

 

[Armen Stein]

Please forget I ever asked. This was so simple. I had a morning brain freeze.

I totalled on the EquipmentID field using "Count" and set a parameter of ">1".

So sorry!
TraciAnn Needs Coffee

Thanks for posting back TraciAnn. You saved someone time in
answering, AND you taught others how you solved it. Far superior to
the "never mind, I figured it out" posts!

Mmm, coffee.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com