PDA

View Full Version : Is it possible to use Sum IF in Access expression



wedd
03-15-2011, 01:31 AM
Hi ms access and vba experts, is it possible to use a sumIF expression or vba code to auto-calculate or add two text boxes...for example based one textbox: the number of hours that someone wants to hire a facility +
one textbox: the price ...I've never used this expression before, so if I am using it in the wrong way can you explain how the sumif expression can be used?


Thanks for your contributions:friends:

OBP
03-15-2011, 11:02 AM
You can use Excel "SumIf" expressions as long as an Excel reference is checked.
But you can also use IIF with Sum inside the expression to sum values a s well.