Count the number of Specific Date occurences in a report

[brentv911]

Be Gentle. This is my first post.

I have a database where i am tracking new applicants for a job. I have a field for "Testing Date". I made this a short text field since i wanted a drop down to only 2 specific dates. now i want to create a text field in the header that shows the number of each date occurrence on the report. I know i could do this with 2 different reports off of 2 queries, but i wanted everything on one report. Obviously i can't share the database as it has personal information in it. Below are a couple of screen shots from my report. The first is the header (still missing the 2nd text box). the 2nd image is the Testing Date column. How do i get it to count and display the number of occurrences for each date?

[brentv911]

I kept working on this and managed to figure it out, thanks to another couple of posts on here. I just created a text box in the header and entered
=Sum(IIf([Testing Date]="10/09/2024",1,0)) and this worked like a charm.

[Welshgasman]

Nothing below?
Please check your posts.
You cannot paste pictures here like you can on other sites. You need to use the attachment option.

I would always keep dates as dates.

[brentv911]

Nothing below?
Please check your posts.
You cannot paste pictures here like you can on other sites. You need to use the attachment option.

I would always keep dates as dates.

Oops. I will remember that for the next time.

Normally i would have liked to keep dates as dates, but i wanted a drop down with only 2 options and i couldn't figure out
now to do that as dates.

[Welshgasman]

You just create a value list.
https://www.google.com/search?q=acce...hrome&ie=UTF-8

Alternatively have those two dates in a table, which would be my way probably, as when another date is needed, it is just added to the table as opposed to having to amend the form.