On Thu, 07 Jun 2007 19:29:37 -0700, Tom van Stiphout <no*************@cox.net>

wrote:

>On Thu, 07 Jun 2007 13:56:16 -0400, Chuck <li*****@schoollink.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