July 27, 20196 yr Hello, im a little stuck. in a DB, I have a field that is a calculation of three other fields, [length], [connector.type], [pairs]. An example in that field might be “100’ G3 15pr” Im trying to do a report that gives me the found count of every value that the calculation field has. Basically, how many “100’ G3 15pr” do I have in my DB Im sure it’s an easy find, but I’m drawing a blank. Is this a simple function I can do in a report, or is it a scripted thing? Can anyone point me in the right direction please? Thank you, Tony
July 28, 20196 yr Fields do not have a found count. If you perform a find, then you can use the Get (FoundCount) function to count the records in the current found set. If you want a report that shows how many records are in each group of records (within the current found set), then sort your records by the category field and place a summary field defined as Count of [any field that cannot be empty] in a sub-summary by category part. Edited July 28, 20196 yr by comment
Create an account or sign in to comment