hi, i have a table that has names of people with a total number of parts for
each respective name. What i want to do is to total the values together and
use it in a text box on a form as a grand total for the department.
Can this be done with code or should one use queries ?
--
Les

I would use code. It's much more flexiable and controlable. For a control
freak like me that works best.

good luck

"Newbie" <(E-Mail Removed)> wrote in message
news:00A08A6D-6B60-4DA0-A07B-(E-Mail Removed)...
> hi, i have a table that has names of people with a total number of parts
for
> each respective name. What i want to do is to total the values together
and
> use it in a text box on a form as a grand total for the department.
> Can this be done with code or should one use queries ?
> --
> Les

=?Utf-8?B?TmV3Ymll?= <(E-Mail Removed)> wrote in
news:00A08A6D-6B60-4DA0-A07B-(E-Mail Removed):

> What i want to do is to total the values together and
> use it in a text box on a form as a grand total for the department.

DSum("NumOfParts", "MyAnatomyTable", "PartsToBeCounted = TRUE")

You can just put the expression into the Controlsource property of the text
box in design view, so you don't need a query or any code!

Hope that helps


Tim F