Record Count Text Box - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Record Count Text Box

Chris Lopez

7 months ago

I have a form, its just a parent form, not bound to anything, it has a subform and several button commands, one of the buttons opens a form to add data when isave thst form, it requries the sub form to.add the new record
All that works, I want to have a text box on the parent form that tracks all new records today , and resets every day for a new daily count.

Any idea how to do this?

	Kevin Robertson @Reply 7 months ago
DCount

	Alex Hedley @Reply 7 months ago
Do you save the `DateCreated` against each record?

	Chris Lopez OP @Reply 7 months ago
Yes. Each date received field has the date in mm/dd/yyyy hhnn format. It puts the current date and time in that field

	Chris Lopez OP @Reply 7 months ago
Alex can Dcount be used when the subform is bound to query, I thought only when bound to a table?

	Alex Hedley @Reply 7 months ago
DCount can ask either

Chris Lopez OP @Reply

7 months ago

I tried to follow the instructions in the techhelp video, but I think I'm missing something.
=NZ(DCount(“*”,”CallT”,”CallID=”&CallID),0) is what I put in the control source.
The count I'm trying to get is from a continuous form that is bound to a Query from the CallT Table. I have a date/time field in the continuous form. I want the count to show just today's count, and reset at midnight.

	Kevin Robertson @Reply 7 months ago
`=DCount("*", "CallT", "DateCreated>#" & Date() & "# And DateCreated<#" & Date() + 1 & "#")` In your example you have stated the Table name. You can change this to whatever your Query is called. Change DateCreated to whatever you have called your DateTime field.

	Chris Lopez OP @Reply 6 months ago
Kevin Thank you, Kevin, that worked to count the calls. Is there a way to update it when I add a call to the subform? I have a separate form that is a data entry form, and when I save it, it requeries the subform to show the new call, but it does not show the count updated unless I close the form and reopen it.

	Kevin Robertson @Reply 6 months ago
`YourCountField.Requery`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View