Unbound form duties

[René]

I have an unbound form that I have set up to give me date parameters for different reports ie I have text boxes with start and end date and command buttons for OK and cancel etc.

We create documentation for several reasons disciplinary, on-site visits etc. These reasons are stored in their own table. How is the best way to generate a report of all disciplinary documentation or supervisory etc from June 1, to July 1

Hopefully that made since. Please keep it simple as I go back to the books to research as necessary but don't always follow

Thanks in advance

 

[Allen Browne]

Take a look at this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

It explains how to set up such a form, and use the WhereCondition of the
OpenReport action to limit the report to a date range.

You can filter on other fields as well by adding to the string for the Where
Condition.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have an unbound form that I have set up to give me date parameters for

different reports ie I have text boxes with start and end date and command
buttons for OK and cancel etc.

We create documentation for several reasons disciplinary, on-site visits

etc. These reasons are stored in their own table. How is the best way to
generate a report of all disciplinary documentation or supervisory etc from
June 1, to July 1

Hopefully that made since. Please keep it simple as I go back to the

books to research as necessary but don't always follow