Get result from summary query into textbox

[accesscomthomas]

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 ????

 

[Crilen007]

so the query isnt associated with the form?

but you want a text box on a form to show that value?

 

[accesscomthomas]

yes , it's not associated ....
or , SHOULD I associate it ? and HOW to associate it ?

i just wanna put the ONLY one result from the query into a textbox (which is bound) .... i feel so poor about how stupid am i

 

[Crilen007]

well
make a subform, and link it to that qry, with a text box, remove the record selectors and everything.

So its just a subform for that textbox.

 

[accesscomthomas]

oh !!!! so clever and tricky !!!!!

thanks