Using query results as selection parameters for a report

[Guest]

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

 

[Les]

If you have a query that gives you the eligible companies,
include all the fields that you want for your report in
the query, then use the query as the data source to the
report. You can change a report's data source by opening
the report in design view, placing the cursor along the
title bar of the report, pressing the right mouse button,
and selecting properties. Record source is the property
to change. If I misunderstood your question, sorry.

-----Original Message-----
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.

 

[Guest]

Thanks Les

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.

Mik

----- Les wrote: ----

If you have a query that gives you the eligible companies,
include all the fields that you want for your report in
the query, then use the query as the data source to the
report. You can change a report's data source by opening
the report in design view, placing the cursor along the
title bar of the report, pressing the right mouse button,
and selecting properties. Record source is the property
to change. If I misunderstood your question, sorry.

-----Original Message----
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..parameter to which generates a report for a particular
company. I have a query that identify which companies are
eligible for a reportfor each of the companies selected by the query?
Preferably without code