I have a query in access that works fine, however I am having trouble binding the query results to a text box. The Sum(LoungeTotalSales) is not a member of the DataReader that I am using and not a field in the table that the query is coming from... I am not sure that this is the place to post this question but I received help from this forum to write the query so I thought I'd give it a try...If this is not the place to post this question any links to help would be appreciated...
SELECT Sum(LoungeTotalSales) AS SumOfL_Total
FROM LoungeSalesSummary
WHERE (((LoungeSalesSummary.L_Date) Between [@BegCalDate] And [@EndCalDate]));
SELECT Sum(LoungeTotalSales) AS SumOfL_Total
FROM LoungeSalesSummary
WHERE (((LoungeSalesSummary.L_Date) Between [@BegCalDate] And [@EndCalDate]));
