Field replaced by an Expression

[diazr]

I'm a newbie to MS Access and I need some guidance. I replaced one of the fields in my form design with the following expression =IIf([AMOUNT]>=10000.01,"YES","NO") so that once a user inputs in the field [AMOUNT] it will automaticly put a YES or NO depending on the amount entered. My problem is how can I store the value of the expression result in the corresponding table assinged to the fields in the form? The field that suppose to be keeping the YES or NO result is [form104]. Any help would be appreciated.

 

[ajetrumpet]

if it is an unbound control, the source is calculation anyway. you don't want those numbers in tables. if you need permanent storage for this stuff, use queries. sounds like tho that it should be a dynamic number when the form is viewed. if so, it doesn't belong in any storage object in the DB. let it be on the fly.

 

[boblarson]

To reiterate what Adam said, you do not need to store this in the table because you can do the same with a query whenever you need it. You have the value and so you can have a base query for your reports or for other queries and just add the field to the query:

MyNewField:IIf([AMOUNT]>=10000.01,"YES","NO")

and there you go - it is good to use. And no storage necessary (and no nightmare situations where some value changes in the table and your "stored value" is off because of it.

 

[ajetrumpet]

And no storage necessary (and no nightmare situations where some value changes in the table and your "stored value" is off because of it.

and no surprises down the road! which result in overages in your budget!