Result of summary query into textbox

accesscomthomas

Registered User.
Local time
Today, 22:12
Joined
Jul 30, 2004
Messages
26
hello, I have created a summary query to calculate a "total" , the query is giving only ONE number (i.e. a table with only 1 row and 1 column) ....
but , HOW could I get that value and put it into a textbox ???? :confused:
 
You can use the DLookUp() function to look up the value.


Put this in the Control Source of the text box (using the correct field name and query name):-

=DLookUp("[field name]","[query name]")
.
 

Users who are viewing this thread

Back
Top Bottom