This is my last automated script...off to a new adventure in 4 days!!
I am wrapping up my last script(S) and need
some direction....Not sure how to approach this.
I have an access database with about 10 or so queries.
I have a script with will run each of the queries to validate data between the database and the a Terminal Emulator.
The script works great however I cannot seem to figure out how to change the query without creating 10 scripts.
This is what I have:
set con = CreateObject("ADODB.Connection")
set rs =CreateObject("ADODB.recordset")
con.provider = "microsoft.jet.oledb.4.0"
rs.open "select PaidAgent, Company, Sum(AmountPaid) as AmountPaid from que_DED_INS_ADAD Group By PaidAgent, Company", con
If not rs.eof Then
while not rs.EOF
All I want to do is change the query (que_DED_INS_ADAD to que_DED_INS_DENT etc)
I am just stuck and I have reached my SQL knowledge limits which is not much.