Total from a Query to a Form

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
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.
Click to expand...

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