Re: Show SUM query results in textbox on form

  • Thread starter Thread starter John Vinson
  • Start date Start date
J

John Vinson

I have a form build around a table which displays the jewelry we have in inventory and the value of each piece.

I have created a query (qryJewelryValue) that is a sum of the value field in the jewelry table.

What I would like to do is show that value on a label or in a textbox but I have not been able to do this. Ideally I would rather not use a subform. Is there a way to do this? And if there is, is there a way to do it without the query table opening up and overlapping the form when the form is run (I tried running the query on load and had this happen).

Any help would be appreciated.
Click to expand...

Use the Form (or Subform's) Footer. Put a textbox in it with a control
source

=Sum([value])

The totals query isn't really needed, though if you want it for some
other reason, you can set the control source of a textbox to

=DLookUp("[SumOfValue]", "qryJewelryValue")

In no case is it necessary to open the query datasheet at all - you
don't need to "run" the query in order for it to have a value!
 
Thank you John this worked like a charm - much appreciated.

John Vinson said:
I have a form build around a table which displays the jewelry we have in inventory and the value of each piece.

I have created a query (qryJewelryValue) that is a sum of the value field in the jewelry table.

What I would like to do is show that value on a label or in a textbox but I have not been able to do this. Ideally I would rather not use a subform. Is there a way to do this? And if there is, is there a way to do it without the query table opening up and overlapping the form when the form is run (I tried running the query on load and had this happen).

Any help would be appreciated.
Click to expand...

Use the Form (or Subform's) Footer. Put a textbox in it with a control
source

=Sum([value])

The totals query isn't really needed, though if you want it for some
other reason, you can set the control source of a textbox to

=DLookUp("[SumOfValue]", "qryJewelryValue")

In no case is it necessary to open the query datasheet at all - you
don't need to "run" the query in order for it to have a value!
Click to expand...
 
Back
Top