Using query results as selection parameters for a report

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

Guest

Hi,

This has probably been asked a million times before, and hopefully easy to answer, but I'm new to this so go easy on me..

I've designed a report that I can manually pass a parameter to which generates a report for a particular company. I have a query that identify which companies are eligible for a report

How do I "read" the query's resutls and generate a report for each of the companies selected by the query? Preferably without code

Thanks in advance for any and all help
Mik
 
Mike
your report has to be driven off a 2nd query.
1st query identifies the companies for report.
2nd query pulls data for report

in 2nd query add in your 1st query and do an equal join
on the company identifier - name or id or whatever you
have to tie the 2 together.

this way, when the 2nd query runs - it will only run
for the companies that are in the 1st query results

the 2nd query is then your data source for the report


-----Original Message-----
Hi,

This has probably been asked a million times before, and
Click to expand...
hopefully easy to answer, but I'm new to this so go easy
on me...
I've designed a report that I can manually pass a
Click to expand...
parameter to which generates a report for a particular
company. I have a query that identify which companies are
eligible for a report.
How do I "read" the query's resutls and generate a report
Click to expand...
for each of the companies selected by the query?
Preferably without code.
 
Thanks Ann,

I probably didn't make myself clear, but I need to generate a separate report for each of the companies that are eligible, not one big report containing all of the eligible companies.

I want the report to run several times (based on how many companies are eligible from the "selection" query), and generate individual reports per company.

I then need to print them separately (with headers, footer and page numbers), or export individual reports for emailing... (I can see another question when I get that far :-))

If it needs code, so be it, but I've never used it...

Hope to hear from you, or anyone else that may be able to help.

Mike


----- ann wrote: -----

Mike
your report has to be driven off a 2nd query.
1st query identifies the companies for report.
2nd query pulls data for report

in 2nd query add in your 1st query and do an equal join
on the company identifier - name or id or whatever you
have to tie the 2 together.

this way, when the 2nd query runs - it will only run
for the companies that are in the 1st query results

the 2nd query is then your data source for the report


-----Original Message-----
Hi,
Click to expand...
hopefully easy to answer, but I'm new to this so go easy
on me...parameter to which generates a report for a particular
company. I have a query that identify which companies are
eligible for a report.for each of the companies selected by the query?
Preferably without code.
 
Back
Top