Daily Count Display on Form

DeLaMartre

Registered User.
Local time
Today, 00:04
Joined
Sep 22, 2002
Messages
12
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,
 
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
 
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,
:)
 

Users who are viewing this thread

Back
Top Bottom