Question Add up values in a table - vba on form.

[DanJames]

I would like to have a textbox on a form:

That adds up the amount of money in query 'CurrentClients', Column 'And'. The data in this field is currency.

 

[AlienRay]

A DSum function would do that.

Set the Record Source of the text box to:
=("[And]","CurrentClients")

By the way, if your field really is named "And", you might want to consider changing it. That's a protected word.

 

[boblarson]

A DSum function would do that.

Set the Record Source of the text box to:
=("[And]","CurrentClients")

I think you forgot to include the DSum

=DSum("[And]","CurrentClients")

 

[AlienRay]

I think you may be right...