M
Mike
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.
Mik
----- ann wrote: ----
Mik
your report has to be driven off a 2nd query
1st query identifies the companies for report
2nd query pulls data for repor
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 result
the 2nd query is then your data source for the repor
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
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
----- ann wrote: ----
Mik
your report has to be driven off a 2nd query
1st query identifies the companies for report
2nd query pulls data for repor
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 result
the 2nd query is then your data source for the repor
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