0 Replies Latest reply on Nov 16, 2012 9:16 AM by George Perros

    want to count the number of instances/occurrances of a field value in a database. Count function just tells me the field value exists in the database (e.g., product code 'BRZ' exists as a field value in the product code field, and returns a value of '1'.

    George Perros

      I want to count the number of instances/occurrances of a field value in a database. Count function just tells me the field value exists in the database (e.g., product code 'BRZ' exists as a field value in the product code field, and returns a value of '1'. I need to count the number of records in the database for which the product code BRZ is positive (i.e., not null and not another product code). I should end up with a histogram with bar height reflecting the number of products with product code BRZ, BRY, CDF, etc.