Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    29

    Unanswered: The "IF" expression

    I'm trying to transfer the following expression fron Excel to Access:
    30+IF(G23>=1,30,0)

    Meaning: 30+ if the value in G23 cell is higher or equal to 1, use value 30, otherwise use 0. Resulting in either 30+30 or 30+0 depending on the value in G23.

    How would this expression be writen in Access please?

  2. #2
    Join Date
    Apr 2004
    Posts
    29
    Found it, is the same, just change "If" to "IIf".

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    With the extra "I" meaning "Immediate" - like someone would ever really want to wait for the calculation...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  4. #4
    Join Date
    Mar 2004
    Posts
    118
    you dont want to wait, but you have to if thers code with an if statment attached... Hance the imidiate... hehe

Posting Permissions

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