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]")
.

yes, great idea

thanks :)