Bounding

[Steve]

Thanks for the answer before! you guys are superstars!

one more then...

if i was wanting to bound this information into a table... how do i bound it
to a coloum and have the formula in the same box?

so... =IIf([overall] = 1,"Pass","Fail") ...then how do i put this data into
coloum 'Outcome'?

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains how you can assign the value. More importantly, it
explains when to do this, and when to use a calcualated field that just
cannot go wrong.

 

[Rick Brandt]

Thanks for the answer before! you guys are superstars!

one more then...

if i was wanting to bound this information into a table... how do i
bound it to a coloum and have the formula in the same box?

so... =IIf([overall] = 1,"Pass","Fail") ...then how do i put this
data into coloum 'Outcome'?

You don't. Data that can be derived from stored data should not be stored.
It should be calculated as needed.

 

[Steve]

so i cannot store the 'pass' or 'fail' result into a table?

Thanks for the answer before! you guys are superstars!

one more then...

if i was wanting to bound this information into a table... how do i
bound it to a coloum and have the formula in the same box?

so... =IIf([overall] = 1,"Pass","Fail") ...then how do i put this
data into coloum 'Outcome'?

You don't. Data that can be derived from stored data should not be stored.
It should be calculated as needed.

 

[Rick Brandt]

so i cannot store the 'pass' or 'fail' result into a table?

You *can*, but it is not necessary and therefore you *should not*.