Variable value from query

N

Neal Ostrander

I have a query that takes the sum of one comlum and subtracts the sum of
another column to get the balance. Is there a way to run this query in vba
and assign the returned value to a variable.

Thanks
Neal
 
P

pietlinden

I have a query that takes the sum of one comlum and subtracts the sum of
another column to get the balance. Is there a way to run this query in vba
and assign the returned value to a variable.

Thanks
Neal
Click to expand...

dim curReturnValue as currency
dim qdf as dao.querydef
dim rs as dao.recordset
set qdf=Dbengine(0)(0).Querydefs("QueryName")
set rs=qdf.openrecordset

curReturnValue=rs.fields("Total")

you mean something like that?
 
N

Neal Ostrander

Is the coding the same using ADO?


[email protected] said:
dim curReturnValue as currency
dim qdf as dao.querydef
dim rs as dao.recordset
set qdf=Dbengine(0)(0).Querydefs("QueryName")
set rs=qdf.openrecordset

curReturnValue=rs.fields("Total")

you mean something like that?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Results of SQL select assign to variable 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Pass the results of a query to a variable 1
Access Running Balance in Access 1
return primary key for record after append query 3
Retrieve result from query 1
Append Query in VBA - to append VBA variable values to Access tabl 4
Running a count query from VBA. 3

Top