Counting Records after filtering by feilds

[breeden.christopher]

I am working on a project that will create a report to count the
number of open work orders (records that have their opendate field
with in a date range given), close work orders (records that have
their closeddate field with in the same date range given earlier) and
pending work orders (records that do not have an entry in the closed
date field). I don't know how to (a) prompt the user for a given date
range, im thinking of maybe using a form interface? Is it possible
for me to have a calander button to click to select a date from there?
and (b) To count the what was previously described from my work orders
table and display it in the Form.

 

[Guest]

Hi Breeden,

This sample includes a form that allows the user to enter a date range:
http://home.comcast.net/~tutorme2/samples/customdialogbox.zip

It also includes Access MVP Allen Browne's calendar functionality:
http://allenbrowne.com/ser-51.html

and (b) To count the what was previously described from my work orders
table and display it in the Form.

This certainly sounds possible.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________