R
Rose
I'm not sure if I should ask this in Queries instead, but as I have 5
intertwined reports that work fine individually, thought I'd try here first.
I have multiple tables and queries that all contain my primary key field -
some as the primary key, some as another field. With one exception, it is the
source of relationships for all my tables and queries.
I had to produce a report that was pulling information from different
sources - some that return one result (from 2 different tables with a
one-to-one due to data import problems), and some that return 5 results
(where I need information on the top 5 competitors in a 3rd table). They are
very mixed up in the order I needed to have them come out on the report. In
order to not choke Access, I split this report into the 5 main sections, each
with their own query to build the report on.
At the first level is ReportPart1. Subreports are ReportPart2, 4 and 5. A
subreport of ReportPart2 is ReportPart3. 3 and 4 are drawing from the top 5
competitors; 1, 2 and 5 are single record returns from my company's data.
The Problem:
I have the queries for reportpart2-5 look to reportpart1 for the parameter
for which primary key number to use. I fully expect one parameter prompt to
appear, since reportpart1 asks for it. However, it asks 7 times before the
first page of the report appears.
Once I type in the correct primary key number in 7 times, my report does
look correct.
Obviously, I shouldn't have to type it in 7 times.
I've tried a few things, and nothing's worked so far. Help!
intertwined reports that work fine individually, thought I'd try here first.
I have multiple tables and queries that all contain my primary key field -
some as the primary key, some as another field. With one exception, it is the
source of relationships for all my tables and queries.
I had to produce a report that was pulling information from different
sources - some that return one result (from 2 different tables with a
one-to-one due to data import problems), and some that return 5 results
(where I need information on the top 5 competitors in a 3rd table). They are
very mixed up in the order I needed to have them come out on the report. In
order to not choke Access, I split this report into the 5 main sections, each
with their own query to build the report on.
At the first level is ReportPart1. Subreports are ReportPart2, 4 and 5. A
subreport of ReportPart2 is ReportPart3. 3 and 4 are drawing from the top 5
competitors; 1, 2 and 5 are single record returns from my company's data.
The Problem:
I have the queries for reportpart2-5 look to reportpart1 for the parameter
for which primary key number to use. I fully expect one parameter prompt to
appear, since reportpart1 asks for it. However, it asks 7 times before the
first page of the report appears.
Once I type in the correct primary key number in 7 times, my report does
look correct.
Obviously, I shouldn't have to type it in 7 times.
I've tried a few things, and nothing's worked so far. Help!