L
la knight
Hoping someone can help me!!!!!
I have 4 queries which are needed to generate this one report. Query1 asks
for users input for a [PART] number, Queries 2 and 3 then reference this part
number for their records and finally Query4 is a UNION query to join the
records from Queries 2 & 3. When the queries are run independently of the
report itself I only have to input the [PART] number once as requested by
Query1, then 2,3 and 4 follow suit using the [PART] input. BUT, when I embed
these queries into reports it requeries Query1 over and over again asking for
input to generate the report. I have tried linking master and child fields
and that has no effect. The reports are layered as follows:
MainReport: Source is Query1 [PART] input needed
SubReport1(In MainReport Footer): Source is Query2
SubReport2(In SubReport1 Footer): Source is UNION Query 4
Is there a way to get the subreports to reference the main report [PART]? I
tried removing the reference to the Query1 [PART] field for the subreports
queries, but I can not get it to work with the UNION QUERY 4; it gives me an
ODBC call failed error message. Presumably because the program is getting
confused. Any suggestions???
I have 4 queries which are needed to generate this one report. Query1 asks
for users input for a [PART] number, Queries 2 and 3 then reference this part
number for their records and finally Query4 is a UNION query to join the
records from Queries 2 & 3. When the queries are run independently of the
report itself I only have to input the [PART] number once as requested by
Query1, then 2,3 and 4 follow suit using the [PART] input. BUT, when I embed
these queries into reports it requeries Query1 over and over again asking for
input to generate the report. I have tried linking master and child fields
and that has no effect. The reports are layered as follows:
MainReport: Source is Query1 [PART] input needed
SubReport1(In MainReport Footer): Source is Query2
SubReport2(In SubReport1 Footer): Source is UNION Query 4
Is there a way to get the subreports to reference the main report [PART]? I
tried removing the reference to the Query1 [PART] field for the subreports
queries, but I can not get it to work with the UNION QUERY 4; it gives me an
ODBC call failed error message. Presumably because the program is getting
confused. Any suggestions???