AnsweredAssumed Answered

Count as calculation field

Question asked by sdurante on May 16, 2018
Latest reply on May 16, 2018 by beverly

I have a table of fields:

Date

MemID

 

I would like a third field in each record that reports a total count of records that displays the number of records within a date range for the MemID.

 

So if John, with MemID of "1" has 6 records whose Date is after "1/1/2018," this new field, call it Count, would show "6" in each of his records.

If Mary, with MemID of "2" has 20 records whose Date is after "1/1/2018," this new field, call it Count, would show "20" in each of her records.

 

Any leads would be appreciated.

Outcomes