DlookUp & then adding various fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
I would use code. It's much more flexiable and controlable. For a control
freak like me that works best.

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

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