AnsweredAssumed Answered

Count Records With Criteria Calculation

Question asked by ChrisAustin on Dec 1, 2010
Latest reply on Dec 1, 2010 by philmodjunk

Title

Count Records With Criteria Calculation

Post

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.

Many Thanks,

Chris.

Outcomes