Have report request date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.

Karnegie23 said:
I run a report that shows work orders. Right now it just shows every
Click to expand...
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!
 
Karnegie23 said:
I run a report that shows work orders. Right now it just shows every
Click to expand...
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
 
Back
Top