Consulting

Results 1 to 2 of 2

Thread: Is it possible to use Sum IF in Access expression

  1. #1
    VBAX Mentor
    Joined
    Aug 2010
    Posts
    457
    Location

    Is it possible to use Sum IF in Access expression



    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

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •