Date Form

[klynch0803]

Hey I have seen several people post that it is a solution but i do not see anything saying how to do it.

I want to run reports from a single form and I want to have the start date and the End Date for the reports on the form they run the report from.

My question is how do you have the report look at the dates to run the report on? Example below:

Form "fdatReport"

Field "StartDate"
Field "EndDate"

Button "P&L Report"
Button "Payroll Report"
Button "Sales Detail Report"

Now if I enter
"StartDate" 2-01-2008
"EndDate" 2-12-2008

I would want the report I click the button to run a report I want the results based on that date range.

 

[pbaldy]

Generally you have criteria in the query the report is based on to look at those controls:

Between Forms!fdatReport.StartDate And Forms!fdatReport.EndDate

 

[klynch0803]

TY that did it.. I should have known that I just did that on something else..

How about if I have a combo and if its null then it will run the report on all employees? I know I use same method as above to run on selected employee.

 

[pbaldy]

For one criteria I use this:

http://www.mvps.org/access/queries/qry0001.htm

 

[klynch0803]

TY works great.

Thank You for the push along..