Skip to main content
Question

Counting Instances of a Number in a Table

  • May 23, 2023
  • 0 replies
  • 367 views

Hi everyone - I'm hoping someone out there can help me out.  I have a table that contains a field, Estimate Number.  This Estimate Number repeats but is differentiated by another field, Version Number.  Here's a screenshot of a report that I think explains this better:


I need to create a field within this table that counts the number of estimates.  In the example above it would be 14.  I've tried creating a summary field but there aren't any tables that have the right level of aggregation and where this table is Child.

Thanks!



------------------------------
Scott Cote
------------------------------
    This topic has been closed for replies.

    Scott - did you try using a query field to count the number of records that match the estimate number?  That way if you have gaps in the version numbers - you'd get the right nr of estimates and you could expand it to look at other thinks like status, etc.  Yeah - you're counting in the same table, but that should be just fine. 



    ------------------------------
    joe vandervest
    ------------------------------
    Terms & ConditionsAccessibility statement