Sum query (single value) to appear in a text box - how?

  • Thread starter Thread starter paul.schrum
  • Start date Start date
P

paul.schrum

I am have a SUM query (which works okay). I want to display the value
of that query in a read-only text box on a form. However, when I set
Control Source for that text box to

=[qry_theSumQuery].[summedField]

it does not work for me. I do not see any other way to do this. Can
someone give me some advise on how to do this?

Thanks.

- Paul Schrum
 
one way is in the form's load event, put:

Me.yourTextbox = nz(DLookup("summedfield", "qry_theSumQuery"),0)

Damon
 
Thanks for your response.

I tried your suggestion and it worked.

- Paul
 
You must log in or register to reply here.

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

combo box selection runs query to sum values in table not gettingparameter from combo box 2
suming up text box from other text boxes that have a sum formula 2
Summing on 3 different values 1
Need combo box to refresh when moving to new record 2017 1
Refreshing a query 1
Query Source for Text Box 7
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Special Combo box - how to set up 7

Back
Top