Hey Guys,
I hope I didn't miss a post on this subject already.
I am using Access 2003 through ADO.
I have query 1 (MergeThisLastS eason):
SELECT m2.MemberLevelD esc, m2.CostAmt, m1.MemberLevelI D, m1.SeasonID
FROM MemberLevels AS m2 INNER JOIN MemberLevels AS m1 ON
m2.CurrSeasMbrI D=m1.MemberLeve lID
where m1.SeasonID = [@aseasonid]
and query 2:
SELECT
Sum(InvoiceItem s.ItemQty) AS SumOfItemQty,
MergeThisLastSe ason.MemberLeve lDesc,
MergeThisLastSe ason.CostAmt,
Sum(MergeThisLa stSeason.CostAm t) AS TotAmt,
InvoiceItems.Pe rsonID, InvoiceItems.Se asonID
FROM MergeThisLastSe ason
INNER JOIN InvoiceItems ON
MergeThisLastSe ason.MemberLeve lID=InvoiceItem s.MemberLevelID
WHERE MergeThisLastSe ason.SeasonID=I nvoiceItems.Sea sonID
GROUP BY MergeThisLastSe ason.MemberLeve lDesc,
MergeThisLastSe ason.CostAmt, InvoiceItems.Pe rsonID,
InvoiceItems.Pe rsonID, InvoiceItems.Se asonID;
I used to have [@aseasonid] hard coded to a value but now I want it as
a parameter
How do I get query 2 to execute query 1 (MergeThisLastS eason) with a
parameter?
Dazed and confused,
~Gina_M~
I hope I didn't miss a post on this subject already.
I am using Access 2003 through ADO.
I have query 1 (MergeThisLastS eason):
SELECT m2.MemberLevelD esc, m2.CostAmt, m1.MemberLevelI D, m1.SeasonID
FROM MemberLevels AS m2 INNER JOIN MemberLevels AS m1 ON
m2.CurrSeasMbrI D=m1.MemberLeve lID
where m1.SeasonID = [@aseasonid]
and query 2:
SELECT
Sum(InvoiceItem s.ItemQty) AS SumOfItemQty,
MergeThisLastSe ason.MemberLeve lDesc,
MergeThisLastSe ason.CostAmt,
Sum(MergeThisLa stSeason.CostAm t) AS TotAmt,
InvoiceItems.Pe rsonID, InvoiceItems.Se asonID
FROM MergeThisLastSe ason
INNER JOIN InvoiceItems ON
MergeThisLastSe ason.MemberLeve lID=InvoiceItem s.MemberLevelID
WHERE MergeThisLastSe ason.SeasonID=I nvoiceItems.Sea sonID
GROUP BY MergeThisLastSe ason.MemberLeve lDesc,
MergeThisLastSe ason.CostAmt, InvoiceItems.Pe rsonID,
InvoiceItems.Pe rsonID, InvoiceItems.Se asonID;
I used to have [@aseasonid] hard coded to a value but now I want it as
a parameter
How do I get query 2 to execute query 1 (MergeThisLastS eason) with a
parameter?
Dazed and confused,
~Gina_M~
Comment