In a form, how to query a table to count records between dates entered on form

**amycclark** · 07-26-2012, 10:12 AM

I have a form with a place for users to enter a start date and end date.
I'd like a box in my form to show the number of records in a table where the field is between these dates.

Seems simple enough but my head is spinning reading things online.

Example record in my table called "MyTable".

Reviewer Reviewed file by
Amy 1/3/2012
Josh 2/5/2012
. .
. .
. .

On my form I have a start date and end date.
I'd like a box in my form to show the number of files that were reviewed between the dates entered by the user.

Any assistance for this newbie would be MUCH appreciated!!!!
~Amy

**RuralGuy** · 07-26-2012, 10:51 AM

It sounds like a job for DCount(). http://access.mvps.org/access/general/gen0018.htm

In a form, how to query a table to count records between dates entered on form

Thread Tools

In a form, how to query a table to count records between dates entered on form

Similar Threads

Information not displaying correctly in table once entered in form

Limit records entered in subform based on main form

VBA: Run Query then Count number of Records then Display number on a form

Form records to appear in order as they are entered

Table form with records from a query to insert results in a different table

Posting Permissions