Excel equation to Access Equation

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Chuck
    #1

    Excel equation to Access Equation

    Is the any way to convert an equation in Excel to something Access will
    understand other than manually rewriting the code?
    Basic equation has several *MOD(A,B) and several IF(AND(C,D)...
    simply changing MOD(A,B) to (A MOB B) and changing
    IF(AND(C,D)... to IIF(C AND D)... does not do the trick. I suspect I'm having
    parentheses problems. A, B, C, and D are themselves complex equations.

    Chuck
    Tags: None
    • Tom van Stiphout
      #2
      Re: Excel equation to Access Equation

      On Thu, 07 Jun 2007 13:56:16 -0400, Chuck <libbeyc@school link.net>
      wrote:

      No, you're on your own.
      -Tom.

      >Is the any way to convert an equation in Excel to something Access will
      >understand other than manually rewriting the code?
      >Basic equation has several *MOD(A,B) and several IF(AND(C,D)...
      >simply changing MOD(A,B) to (A MOB B) and changing
      >IF(AND(C,D). .. to IIF(C AND D)... does not do the trick. I suspect I'm having
      >parentheses problems. A, B, C, and D are themselves complex equations.
      >
      >Chuck

        Comment

        • Chuck
          #3
          Re: Excel equation to Access Equation

          On Thu, 07 Jun 2007 19:29:37 -0700, Tom van Stiphout <no.spam.tom774 4@cox.net>
          wrote:
          >On Thu, 07 Jun 2007 13:56:16 -0400, Chuck <libbeyc@school link.net>
          >wrote:
          >
          >No, you're on your own.
          >-Tom.
          >
          >
          >>Is the any way to convert an equation in Excel to something Access will
          >>understand other than manually rewriting the code?
          >>Basic equation has several *MOD(A,B) and several IF(AND(C,D)...
          >>simply changing MOD(A,B) to (A MOB B) and changing
          >>IF(AND(C,D).. . to IIF(C AND D)... does not do the trick. I suspect I'm having
          >>parentheses problems. A, B, C, and D are themselves complex equations.
          >>
          >>Chuck
          Thanks Tom. I was pretty sure this would be the case. Finally got it right
          after my post.

          Chuck


            Comment

            Previous template Next
            Working...