how to get the count under different values in the same feilld.

[prasadbuddhika]

in my data base in the order table there is a status field and it has many different values relevant to orders and order table has a relationship with customers table on customercode, what i want is to get the count of each order status relevant to each customer.any idea how

[Mycroft Holmes]

Look into the group by clause.

Select count(*), Customer, Status
From Table
Group By Customer, Status

Never underestimate the power of human stupidity RAH