Get a query inside a text field

[herbertioz]

I need to get a query who calculate Sum(). The query are working, but I cant get it to "print" out in the textfield. Why not?

 

[pbaldy]

You can't refer directly to a query that is not part of the record source of the form. You could get the value with a DLookup() if you want (or maybe skip the query and use a DSum()).

 

[herbertioz]

You can't refer directly to a query that is not part of the record source of the form. You could get the value with a DLookup() if you want (or maybe skip the query and use a DSum()).

Thanks for answer
Do you have a sample code for the Dlookup and Dsum?

 

[pbaldy]

Good reference on syntax here:

http://www.mvps.org/access/general/gen0018.htm