Date Count

  • Thread starter Thread starter Richard Martin
  • Start date Start date
R

Richard Martin

I have a text box on a form that I want to give me a
count of how many time today's date appears in the
[Apply_Date] field. Any help will be appreciated.
 
I have a text box on a form that I want to give me a
count of how many time today's date appears in the
[Apply_Date] field. Any help will be appreciated.
Click to expand...

Set that textbox's Control Source to

=DCount("*", "[your-table-name]", "[Apply_Date] = #" & Date() & "#")
 
Richard,

Here are 3 ideaas to get you started...

1. Base your form on a Totals query, with Group By [Apply_Date],
Count, with Date() in the criteria of the Apply_Date column.

2. Use the DCount function in the control source property of the
textbox, something like...
=DCount("*","YourTable","[Apply_Date]=Date()")

3. If the form is in continuous view, put the textbox in the form
footer section, and use this control source...
=Abs(Sum([Apply_Date]=Date()))

- Steve Schapel, Microsoft Access MVP
 
Thanks for the help..
-----Original Message-----
Richard,

Here are 3 ideaas to get you started...

1. Base your form on a Totals query, with Group By [Apply_Date],
Count, with Date() in the criteria of the Apply_Date column.

2. Use the DCount function in the control source property of the
textbox, something like...
=DCount("*","YourTable","[Apply_Date]=Date()")

3. If the form is in continuous view, put the textbox in the form
footer section, and use this control source...
=Abs(Sum([Apply_Date]=Date()))

- Steve Schapel, Microsoft Access MVP


I have a text box on a form that I want to give me a
count of how many time today's date appears in the
[Apply_Date] field. Any help will be appreciated.
Click to expand...

.
Click to expand...
 
Back
Top