Access formula

[wheddingsjr]

Hi all

I am trying to find a way to use a formula in Access so that I can complete a project where I am trying to determine the number of dates of service within a group. I typically use a simple formula in excel but there are too many lines and it locks up. I can either do a few at a time using excel or drop the spreadsheet in access and do them all at once if thats at all possible. I am including an example so that there is an idea of what I am trying to accomplish. The column in question is the "Date Count" column. The excel formula that I am using in that column is


'=COUNTIF($A$2:A2,A2)'.

MEMNO	DATE COUNT	UNIQ DOS	BEGDATE
097401	1	1	02/19/16
097401	2	1	05/16/16
097401	3	1	08/18/16
100501	1	1	01/25/16
100501	2	1	10/11/16
108200	1	1	12/08/16
108201	1	1	04/29/16
108201	2	1	04/30/16
108201	3	1	10/21/16
124600	1	1	02/11/16
125900	1	1	12/21/16
160101	1	1	06/03/16
160601	1	1	04/08/16
225000	1	1	03/30/16
225001	1	1	07/07/16
319400	1	1	03/22/16
319400	2	1	10/08/16
337100	1	1	02/21/16
337101	1	1	02/28/16
337101	2	1	08/01/16

Thanks

[JoeM]

Take a look at the DCOUNT function: https://www.techonthenet.com/access/...ain/dcount.php

[rpeare]

If you're doing this in access, use an aggregate query

SELECT BEGDATE, Count(MemNo) as RecordCount FROM tblTABLENAME

[wheddingsjr]

Thanks JoeM

Unfortunately, that was not very helpful. It wasnt quite what I was looking for.

[JoeM]

Sorry, I misread the question and thought you were looking for a Total Count of each MEMNO value, not a Running Count of each one.
Paul (pbaldy), who is active on this site, showed someone how to do that on another site in this thread: https://access-programmers.co.uk/for...d.php?p=941585

[wheddingsjr]

Sorry, I misread the question and thought you were looking for a Total Count of each MEMNO value, not a Running Count of each one.
Paul (pbaldy), who is active on this site, showed someone how to do that on another site in this thread: https://access-programmers.co.uk/for...d.php?p=941585

wow...that was perfect. I did have a small issue and responded to Paul but other than that this is EXACTLY what I was looking for...Thanks a mil Joe

[JoeM]

Its kind of funny, I misunderstood the question, but the suggestion of DCOUNT was part of the solution, just not in the way I first envisioned.
Thanks to Paul's wizardry and use of it!