how to assign result of a Sum() query to a value or caption?

  • Thread starter Thread starter SamwiseGamgee
  • Start date Start date
S

SamwiseGamgee

I created a "Sum of Desposits" query. How do I assign the result of tha
query to a control's caption or value.

I know you can do something like Subform.RecordSource="Sum o
Desposits" and see the value in the subform.

How do I do something like,

Dim x as Currency

x = "Sum of Deposits"

txtBoxBalance.value = x or lblBalance.Caption = x

Thank you very much for any help
 
SamwiseGamgee said:
I created a "Sum of Desposits" query. How do I assign the result of that
query to a control's caption or value.
Click to expand...

Obviously only if the query has one field. Set the controlsource of that
control to
=DLookup("nameOfThatField","Sum of Desposits")

(I thought the term is Deposits?)
 
Back
Top