Daily Count Display on Form

[DeLaMartre]

I have an Access form on which daily work items are recorded. I want to display a running total for the current day's entries on this same form. Being somewhat of a newbie on Access, I am having trouble setting this up.

A simple text box which shows the count of records entered for the current day, would be perfect. As I see it, a background formula using a current date function and a count function would seem to be the approach, but I am not succeeding in putting this together.

Any help will be greatly appreciated.

Thank you,

 

[DES]

Right Approach

You are right you need an unbound text box. It's control source should be a DCount function counting a date field in the table where the date field equals todays date.

If you need more help setting it up email me and I will see what I can do for you.

DES

 

[DeLaMartre]

Thanks so much, DES. A DCount function counting a date field is just the advice I needed to get my head together on this problem!

Your help is very much appreciated.

I see you are from Ontario. Having been born and raised in Minnesota, I have many fond memories of Ontario and the rest of the North Land.

Regards,