assign value to label

[collinm]

hi

in vba i done a query
strQuery
strQuery = "select sum(x) as X, sum as Y from test3"

how to run this query and get sum(x) value, sum value and
set it to label

txtX.caption = ...
txtYCaption = ...

any idea?

thanks

 

[mdow]

Me.txtX.caption = DSum(X, domain, [criteria])
Me.txtY.caption = DSum(Y, domain, [criteria])