S
Sharon M via AccessMonster.com
I have the following union query:
SELECT qryB.*, qryA].*
FROM [qryB] left join [qryA]
ON qryB.Act_No = qryA.Act_No
UNION SELECT qryB.*, qryA.*
FROM qryA left join qryB]
ON qryA.Act_No = qryB.Act_No;
This returns two colums with qry_A.Act_No and qry_B.Act_No.
Some qry_A.Act_No and qry_B.Act_No fields are null, but what i would like to
do is merge these fields to a new column called Act_No, so that i can dump a
subreport into a report by using the Act_No.
the problem i'm having so far is that i can only use one column or the other
to define the subreport, even if i define my own relations the child link can
only have one reference.
can anyone help?
SELECT qryB.*, qryA].*
FROM [qryB] left join [qryA]
ON qryB.Act_No = qryA.Act_No
UNION SELECT qryB.*, qryA.*
FROM qryA left join qryB]
ON qryA.Act_No = qryB.Act_No;
This returns two colums with qry_A.Act_No and qry_B.Act_No.
Some qry_A.Act_No and qry_B.Act_No fields are null, but what i would like to
do is merge these fields to a new column called Act_No, so that i can dump a
subreport into a report by using the Act_No.
the problem i'm having so far is that i can only use one column or the other
to define the subreport, even if i define my own relations the child link can
only have one reference.
can anyone help?