Report based on 3 union queries - PLEASE HELP!!

[lstantliff]

Consider me a newbie for this thread!! I am trying to create a report with 3 sections, DIRECT HOURS, INDIRECT HOURS, SUMMARY. The information that needs to be viewed under each section is based on a separate union query. Each query is based on parameters, the same parameters apply for each section. Also, column headings will be the same for each section. What is the best (easiest) way to create this report?

 

[lstantliff]

report created - need help with parameters!!

I have created the report I needed by creating a subreport for each union query and combining in 1 report. The report now prompts me 3 times for the parameters. Is there a way to only input this info once as the parameters are the same for all three subreports. I need a creative idea for newbies. I only know a little about code and SQL.

Thanks in advance for any help or ideas!!

Laura

 

[Smart]

RE:report created - need help with parameters!!

You could create a form with a text box for each parameter

In your query in the relevant column (wher the parameters need to be)
type forms![newformname]![field1name]
repeat for each parameter in each query

on the form create a button to run the report

the report via the queries will take the parameters from the form

 

[lstantliff]

Gotcha - can create a button to run report, how does the report and subreports know to use the form as parameters? And for all 4 subreports?

 

[KeithG]

Because you type in Forms![FormName]![TextBoxName] in the criteria row of the query. Every time the report is ran it will use the value supplied in the text box.

 

[lstantliff]

Okay - that's simple enough, I was overthinking the problem. Thanks for the help!