Display results based on a date range

[PJSmith via AccessMonster.com]

Hello,

I’m trying to creating a form that will display info from my table called
“tblCallsâ€. I would like the info to be display between to a “Date†range
entered by the user. Within my “tblCalls†there is a field that contains the
date of each record.

In my form called “frmCallLog†are the two textboxes, in which the user will
enter the desired date ranges “Calls from [textbox “8/20/06â€] through to
[textbox “8/20/07â€].†The form will then auto populate with the results.

There are many textboxes that will at that time auto populate with results,
such as, how many times does “Jasonâ€, “Bobâ€, and “Steve†appear in the “Empâ€
field in “tblCalls†and display the results in a textbox labeled “Employeesâ€.


Many of the textboxes need to add the number of times a specific text or
several specific pieces of text appear in a specific field.

Thanks

 

[Guest]

the user will enter the desired date ranges “Calls from [textbox “8/20/06â€]
through to [textbox “8/20/07â€].â€
Easier that using the textboxes to enter the dates is to use prompts on
opening the form. Under your field that contains the date of each record put
this in the criteria row of the query design view grid --
Between [Enter start date] And [Enter end date]

If you use the forms text boxes you will have to refersh after entering the
data.

 

[Guest]

You can check the following link for info on how to create a custom dialog box:

http://office.microsoft.com/en-us/access/HA010345481033.aspx

HTH