I have a table of customers, which includes contracts
they hold with our firm.
Most customers hold one only contract, however some hold
two and three and a few as high as 5.

This is a flat database and therefore one only table
holds all the data so each contract creates record in the
table with duplicate information related to the
customer. (A customer lookup table or similar is planned
for the future.)

I would like to generate a report based on a query that
selects only those customers that have more than one
contract. therefore more than one record in the table.

All I can think of at this time is that the 'Count
Function' must be used in some way the check if
the 'Customers_ID' exists more than once in the table.
If this is true, then the query must select all records
with that 'Customer_ID' so these and only these records
will be included in the report.

All Comments and ideas welcomed.. Thank you.KMD