I'm having trouble creating a field ("No. of customers supplied by competitors in market") in a query which counts the number of customers who are supplied by competitors in a particular market sector. I think this will involve grouping the "market sector" field and counting the number of customers in the "customers" field for each market. Any suggestions on how to implement this please (urgent)?

[This message has been edited by markb_1984 (edited 02-24-2002).]

VERY surprised no one responded . . .

I'm NOT the resident Access guru. In query design view, hit View-Totals. See the new Totals row down below.

In the Market Sector field, let Group by remain. In the Customers field, choose Count from the dropdown.

~Dreamboat~
TheWordExpert (http://www.thewordexpert.com)