circular formula in Access 2000 or 2002

[rafik]

is there a way to create a circular formula in Access 2000
or 2002
thank's

 

[Newbie]

why would you want to do that?

 

[Guest]

-----Original Message-----
why would you want to do that?



.I have a formula C =A+B+D
and D is a fee witch's a % of C

C= A+B+0.3%C

 

[Ted Allen]

Hi Rafik,

Access is not like Excel where you can have multiple
circular references and go through many iterations. I
think that if you want to use circular references in
Access you would generally have to use VBA or a linked
Excel sheet.

But, for the formula that you provided, I believe that
you could just use:

C = (A + B) / .997

HTH, Ted Allen

 

[david epsom dot com dot au]

Access is not like Excel where you can have multiple

circular references and go through many iterations. I

??? you can't have circular references and interate
in Excel can you ??? unlike older spreadsheets it
resolves and compiles all references ???

(david)

 

[Ted Allen]

Hi David,

Well, I have to admit I haven't had a need to use
circular references for some time (at which time I was
using Quattro Pro). But, as far as I know most (or
possibly all) versions of Excel will let you use circular
references, but will only do a set number of iterations.
Currently I have Office XP, and it will only resolve
circular references over the number of iterations
specified under Tools|Options on the calculation tab.

I agree though, that Excel's approach is much different
than say the old Quattro Pro version, which seemed to
handle them better.

-Ted Allen