Search results for query: *

How would I insert the Start and End Date values into Table2?

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...

I have a query that works fine...What I want to after the query is insert the Sum(LoungeTotalSales) Into another table. Below is the query that works fine... SELECT Sum(LoungeTotalSales) AS SumOfL_Total FROM LoungeSalesSummary WHERE (((LoungeSalesSummary.L_Date) Between [@BegCalDate] And...

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...

SuicidED, Thank you very much!! That is just what I needed!!! dollarbillg

Richard, Thanks but I still need to return just one total for the selected time period. Can this FORMAT function be modified to accept two date parameters to return on record with the total for the designated time period? dollarbillg

I have a table that has the a L_Date field and a L_Totals field. What I am trying to do is write a query that will give me the totals for a specific time period. I have a queries that produced the grand total for all entries (which I dont need) and I have a query that gives me the daily...