Access Date Range

[saratogajoe]

For a Medical Chart Audit database, I need to require the user to choose a "From" date and a "To" date

[NeoPa]

Oh good ?!?

Give us a clue as to the question?

[saratogajoe]

Oh good ?!?

Give us a clue as to the question?

I need to develop a report which will give the user a compliance rate for provider completion of various things on a medical chart. i.e "provider signature on a treatment plan for a patient." Chart Review auditors will input the results of their chart audits into a database that I developed. They need a report which will give them a completion rate % for individual providers or categories of chart items -
within a specified date range. So that when they click on the repot, they will be prompted by a message box that asks for the Beginning DATE AND THE ENDING DATE OF THE PERIOD THEY WISH TO INQUIRE ABOUT.

I hope that helps a little.
Thanks,

[Killer42]

I need to develop a report which will give the user a compliance rate for provider completion of various things on a medical chart. i.e "provider signature on a treatment plan for a patient." Chart Review auditors will input the results of their chart audits into a database that I developed. They need a report which will give them a completion rate % for individual providers or categories of chart items -
within a specified date range. So that when they click on the repot, they will be prompted by a message box that asks for the Beginning DATE AND THE ENDING DATE OF THE PERIOD THEY WISH TO INQUIRE ABOUT.

I hope that helps a little.
Thanks,

At the simplest level, a query can prompt for parameters by including things like...

SELECT * FROM <table> WHERE <Field> Between [Enter the FROM Date] And [Enter the TO Date];

This will cause two dialogue boxes to pop up when the query is executed, prompting "Enter the FORM Date" and so on.

[NeoPa]

A typical way to do this is have a form with TextBoxes (or in this case maybe even Calendar controls) in which the operator can select the dates.
On the click of a button that you add to the form, the code behind the button executes a call to run the report. One of the parameters to this is a WhereCondition to be applied. Here you would enter the SQL code to filter by the dates on your form.

OpenReport Method
The OpenReport method carries out the OpenReport action in Visual Basic.

expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)
expression Required. An expression that returns a DoCmd object.

ReportName Required Variant. A string expression that's the valid name of a report in the current database. If you execute Visual Basic code containing the OpenReport method in a library database, Microsoft Access looks for the report with this name, first in the library database, then in the current database.

View Optional AcView. The view to apply to the specified report.

AcView can be one of these AcView constants.
acViewDesign
acViewNormal default Prints the report immediately.
acViewPivotChart Not supported.
acViewPivotTable Not supported.
acViewPreview

FilterName Optional Variant. A string expression that's the valid name of a query in the current database.

WhereCondition Optional Variant. A string expression that's a valid SQL WHERE clause without the word WHERE.

WindowMode Optional AcWindowMode. The mode in which the form opens.

AcWindowMode can be one of these AcWindowMode constants.
acDialog The form's Modal and PopUp properties are set to Yes.
acHidden The form is hidden.
acIcon The form opens minimized in the Windows taskbar.
acWindowNormal default The form is in the mode set by its properties.

OpenArgs Optional Variant. Sets the OpenArgs property.

You would typically use

DoCmd.OpenReport(...)

[saratogajoe]

At the simplest level, a query can prompt for parameters by including things like...

SELECT * FROM <table> WHERE <Field> Between [Enter the FROM Date] And [Enter the TO Date];

This will cause two dialogue boxes to pop up when the query is executed, prompting "Enter the FORM Date" and so on.

THANKS. PROBLEM SOLVED
SIMPLE IS GOOD. I WILL CALCULATE THE %'S U7SING OTHER QUERIES.
SORRY TO SOUND SO STUPID.