two in one

[sphere]

hello
i have a little favor to ask..
i have two identical reports for different departments.
instead of having these two reports, i just want to have one. then i want to be able to ask for the records of department A or B (by means of criteria).
the headers would have to be diifferent. for the rest everything's the same.
can someone please tell me how to do this??..
the ideal would be to have a popup box asking which records to extract.
thanks alot!
=)

 

[jatfill]

create form that had a combo box based on the departments, so that users can just select which department they need from a list.
In the report, set the department's unique ID or value equal to whatever value is on the form...

=Forms![formname]![departmentID]

with this method, it wouldn't mater if you had just 2 or 200,000 departments, the report always looks at the user selected criteria...

 

[sphere]

thank you so much.
now, does this mean that everytime i want to run a report i have to first go through running the form and selecting the dept. then closing the form and opening the report?
if yes, is there a shorter way, like using a box similar to the 'enter parameter value' on the report itself?
again thanx...

 

[jatfill]

you can use the box (i.e. set the report criteria for the Department field to [Enter Department Name], but really you can tie an event to a button on the query form that opens the report (either in preview mode or send it directly to the printer), then closes the form itself... makes it very neat and easy to navigate, once the report is open/printed, the criteria form closes

 

[sphere]

thanx for the box pointer...
you got me thinking about tying the event though...
could you specify some more on how and where i can get this done.