G
Guest
I create a QueryDef using the following code:
Dim dbs As Database, qdf As QueryDef, strSQL As String
Set dbs = CurrentDb
strSQL = "SELECT * FROM dbo_tblTransactions WHERE
Acct = '" & strAcctNum & "'"
dbs.QueryDefs("qryTransactions").SQL = strSQL
It works fine.
Question: One of the fields includes dollar amounts. How can I add up all
the dollar amounts of the records returnrd in my QueryDef?
Dim dbs As Database, qdf As QueryDef, strSQL As String
Set dbs = CurrentDb
strSQL = "SELECT * FROM dbo_tblTransactions WHERE
Acct = '" & strAcctNum & "'"
dbs.QueryDefs("qryTransactions").SQL = strSQL
It works fine.
Question: One of the fields includes dollar amounts. How can I add up all
the dollar amounts of the records returnrd in my QueryDef?