I have been using query to print report . But what i only can do is printing report one or 12 month for all data user. So is there any way to print and allow user to choose specify date in between for print report for all user in database?
Two options spring to mind. One you can modify your existing query into a parameter query, which will prompt users at runtime to enter a start and finish date.
Another option is to place a couple of listboxes onto your form feeding selected dates as parameters to the query.
Hope this helps
Thanks a lot !!