Unbound form duties

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

René - 27 Jun 2004 23:37 GMT

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

Reply to this Message

Allen Browne - 28 Jun 2004 05:43 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
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
>
> Thanks in advance

Reply to this Message