Referencing a sum query result in a text box

  • Thread starter Thread starter Darrell Cyphers
  • Start date Start date
D

Darrell Cyphers

How does one go about getting the result of a sum query to
appear in a text box?
 
Darrell,

It depends really on the specifics of what you mean. If you have a
query that just returns one value, or one record, you could use an
expression similar to this in the Control Source of your textbox,
presumably on a form or a report...
=DLookup("[NameOfTotalField]","NameOfQuery")
If you have a query that produces totals according to groupings of your
data, and if this is related to the other data in the form/report, and
if a form, assuming you don't need to edit or enter data, you can
probably include the totals query into the existing query that the form
is based on.
If this doesn't help, please post back with more details of what you are
trying to achieve.
 
Back
Top