Forum Discussion
Period of Time on a Report
The standard method most experienced Access developers use is to launch the query from a form.
On that form you place two text box controls: StartDate and EndDate.
In the query, change that criteria reference from the input boxes to the controls on the form:
Between Forms!YourFormNameGoesHere.txtStartDate and Forms!YourFormNameGoesHere.TxtEndDateNow, the query is filtered on open by the values in those controls.
And, your report can ALSO have two controls that reference those same form controls
=Forms!YourFormNameGoesHere.txtStartDate
and
=Forms!YourFormNameGoesHere.TxtEndDate
The standard method most experienced Access developers use is to launch the query from a form.
On that form you place two text box controls: StartDate and EndDate.
In the query, change that criteria reference from the input boxes to the controls on the form:
Between Forms!YourFormNameGoesHere.txtStartDate and Forms!YourFormNameGoesHere.TxtEndDate
Now, the query is filtered on open by the values in those controls.
And, your report can ALSO have two controls that reference those same form controls
=Forms!YourFormNameGoesHere.txtStartDate
and
=Forms!YourFormNameGoesHere.TxtEndDate
- Thank you so much
