Over-ride the results of a Calculation

[Eunmi66]

I realize that data cannot be entered into a calc field, however this is what I would like to do.

I would like the ability to override the results of the calculation.

i.e. if the calc field displays $1.25 (as the result of the calculation)I would like to be able to override this figure and enter my own figure of $1.40.

Is there any way to do this...or make it appear this is happening?

Respectfully

Eun Mi

[LiveOak]

How about defining and extra field:

TotalEntry (number)

Total (Calculation, number) =

If (notIsEmpty(TotaEntry), Total Entry, Quantity * Price)

This field can be stacked behind the Total field. Make Total opaque, set it as don't "Allow modification" and take it out of the tab order. When you click on Total, the TotalEntry field behind it will be selected.

-bd

[Eunmi66]

Thank you Chuck,

I'll see if that will do what I need (given the scenario I'm using)

With gratitude,

Eun Mi

Edit: Spelling

[ July 16, 2001: Message edited by: Eunmi66 ]

[ July 16, 2001: Message edited by: Eunmi66 ]

[Eunmi66]

Brent,

My mosty humble apologies. I am embarrassed to tears. If you have never seen yellow face turn red, you should be here. Looks something like a CorelDraw palette.

So very sorry, and I am truly thankful.

Thank you Brent

Eun Mi

Edit: Spelling

[ July 16, 2001: Message edited by: Eunmi66 ]

[LiveOak]

This is Brent at Live Oak Systems. I do hope my responses measure up the the excellent advice Chuck provides!

-bd