A data source for a calc field in Report Footer

[ekje]

Hi,

Usually a data source for a text box control is a field of a table.
If it is appropriate that the data source for a calculated field is actually the result of a query:
how could the result of a query be transferred as a data source for the calculated field?
Thank you for the answer!

 

[plog]

via Dlookup():

MS Access: DLookup Function

This MSAccess tutorial explains how to use the Access DLookup function with syntax and examples. The Microsoft Access DLookup function returns a value from an Access table (or domain).

www.techonthenet.com

 

[ekje]

Thank you for your reply!