Error: "Name not unique in this context"

rbuser

Hi

I'm trying to link two queries when both are using the same tables and
calculations with different criterias and when I try to veiw the data from
detail query it displays this message "Name not unique in this context".

Query1 Master
SELECT ReceiveDetail.MasterID,
SUM(ReceiveDetail.Amount) SUM_ReceiveDetail_Amount
FROM "ReceiveDetail" ReceiveDetail
WHERE ( ReceiveDetail.CampaignID = "P2001" )
GROUP BY ReceiveDetail.MasterID

Query2 Detail
SELECT ReceiveDetail.MasterID,
SUM(ReceiveDetail.Amount) SUM_ReceiveDetail_Amount
FROM "ReceiveDetail" ReceiveDetail
WHERE ( ReceiveDetail.CampaignID = "P2002" )
GROUP BY ReceiveDetail.MasterID

if anyone knows how to bypass this error let me know please.

Thanks
Sam

digitalmetaphors

Please do not crosspost, I replied in the Datapipelines thread:)


Cheers,

Jim Bennett
Digital Metaphors