Have report request date

[Guest]

I run a report that shows work orders. Right now it just shows every single work order. However, when I click on a button to create the report, I want the report to ask me what dates I want all the work orders for. Can anyone help me with this? Thanks!

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

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

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

I run a report that shows work orders. Right now it just shows every

single work order. However, when I click on a button to create the report, I
want the report to ask me what dates I want all the work orders for. Can
anyone help me with this? Thanks!

 

[larry]

I run a report that shows work orders. Right now it just shows every

single work order. However, when I click on a button to create the report, I
want the report to ask me what dates I want all the work orders for. Can
anyone help me with this? Thanks!

Check out the Northwind sample database. If you have Access 2002 (that's XP)
look at the Sales Report Dialog form and its code. Especially look at the
Sales by Year query as that is where the dates are collected. I don't have
Access 97 handy but I think its examples were better.

Larry