R
rafik
is there a way to create a circular formula in Access 2000
or 2002
thank's
or 2002
thank's
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Newbie
why would you want to do that?
G
Guest
C= A+B+0.3%C-----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
T
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
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
D
david epsom dot com dot au
Access is not like Excel where you can have multiple
??? you can't have circular references and interate
in Excel can you ??? unlike older spreadsheets it
resolves and compiles all references ???
(david)
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)
T
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
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