Count Records With Criteria Calculation
Hello. As a feature of my database I would like users to be able to see at a glance the number of products we supply each customer. In the hope of achieving this I have made a table with 2 fields in addition to the large products database. 1 field for the customer name (e.g. Wilkonsons) and 1 field for the number of products we supply them (e.g. 12). In plain english the Number of Products field would say:
Search the customer field in the main products database (e.g. for Tesco) and count the number of records that are returned. Use this number as the value.
Hope that made sense.