tatendatiffany
Board Regular
- Joined
- Mar 27, 2011
- Messages
- 103
So i want to create a recordset containing sql queries that i am going to call in a loop. but the thing is i am facing difficulty with the recordset, i know it is a stupid mistake that i am making please help :
"Dim strSQL1 As String
strSQL1 = "SELECT COUNT (INUNACPT) FROM AIS3AM4.KTPT80T WHERE CDPRODCO=RETAIL_MAP"
Set rs = mydb.OpenRecordset(strSQL1)"
i have 28 more sql queries that i want to add in the recordset, so do i need to do 28 individual queries?? or i can add all of them in here, and also what am i missing in this recordset so far as its not displaying anything??

"Dim strSQL1 As String
strSQL1 = "SELECT COUNT (INUNACPT) FROM AIS3AM4.KTPT80T WHERE CDPRODCO=RETAIL_MAP"
Set rs = mydb.OpenRecordset(strSQL1)"
i have 28 more sql queries that i want to add in the recordset, so do i need to do 28 individual queries?? or i can add all of them in here, and also what am i missing in this recordset so far as its not displaying anything??

