Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can not create childlist error....
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...- que4life
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
Insert data based on a previous query
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...- que4life
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Binding query in VB.Net
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...- que4life
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
Query help with totals?
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...- que4life
- Thread
- Replies: 7
- Forum: Microsoft: Access Tables and Relationships
