Total from a Query to a Form

[Chris]

Hello,

I have several queries that have count totals from certain fields in a
table. I would like to be able to insert those totals (just the
numbers) on certain places in another form for a manager's summary
view. How can I make this possible.

Thanks in advance.

 

[OldPro]

Hello,

I have several queries that have count totals from certain fields in a
table. I would like to be able to insert those totals (just the
numbers) on certain places in another form for a manager's summary
view. How can I make this possible.

Thanks in advance.

You could declare a public variable in a module to hold a total, or
you could declare a public variable in a form and refer to the form
and the variable like this: someform.somevariable. You could also
just use DSUM( ) with your query string to redetermine each total and
assign it to the textbox on your manager's form. Did you have a more
specific question?