display several calculated fields on a single form view

[Kay Davies]

Hello everyone.

I am totalling 4 different columns, each in an individual query. Is it possible to show these results all on the same page of a form so that I don't have to run each query to see each result.

I hope this makes sense.

Many thanks. regards Kay

 

[pbaldy]

Would a DSum() work for you?

 

[Mr. B]

Have you tried combining all four fields (one from each query) into a single query (not linking them but just placing each calculated field into one query) and then use this new query as your forms record source?

One other way to do this would be to use VBA code to open each query as a recordset, retreive the desired calculation from each recordset and assign the extracted value to a control on your form.

 

[Kay Davies]

Thanks - Mr B your answer of using one query worked a treat!

 

[Mr. B]

You're welcome. Glad to help.