I am looking for a way to do the following. I have 3 fields in an Access Database that combine to identify a new grouping. I would like to run a cumulative count within each grouping based on date (oldest to newest). So if a, b, and c are all equal then based on a sorted d (date), run a cumulative count on how many times a, b, and c are equal. 1 for the oldest date, 2 for next oldest, all the way to x for the newest date. In Excel, I could use a countifs formula after a date sort and limit the range for cell to only the cells above it countifs($A$2:A2, A2, $B$2:B2, B2, $C$2:C2, C2) autofilled down. I am looking for the best advice on how to do this in Access. I tried exporting, but there are too many rows.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
CountIf Function
- Thread starter FBandData
- Start date
