Below is a stored procedure that gives the desired record when run in access...When I run the sp in vn.net I am getting an error that it can not create a childlist for the field tmpLoungeSales. I have other queries that work fine in the code. Any and all help is appreciated.
INSERT INTO tmpTotalLoungeSales ( Total_LoungeSales )
SELECT Sum(LoungeTotalSales) AS SumOfL_Total
FROM LoungeSalesSummary
WHERE (((LoungeSalesSummary.L_Date) Between [@BegCalDate] And [@EndCalDate]));
Thanks
INSERT INTO tmpTotalLoungeSales ( Total_LoungeSales )
SELECT Sum(LoungeTotalSales) AS SumOfL_Total
FROM LoungeSalesSummary
WHERE (((LoungeSalesSummary.L_Date) Between [@BegCalDate] And [@EndCalDate]));
Thanks
