I have a database that keeps track of inventory. I have a field [location] that has only 4 options. How do I get a count of the records with each of the 4 options? I would like to put a global on a layout that would tell the user how many of a certain type of product is in each of the 4 locations. Any help would be appreciated!

Thank you,

Tony

create 4 fields that are a text calc, each equals the static options... such as "Option A"

create 4 relationships from each of these calc fields to the location field

optionA ---

optionB ---

optionC ---

optionD ---

then you can create a calc that concatenates a count () function with text and format it like:

Option A (735)

Option B (23)

Option C (02)

Option D (32)

Thank you! I seem to always be looking at a more difficult way to do things. This is exactly what I was looking for!