Expression / Control?

[WVUFan]

HI,

I am a new Access user so forgive the novice question.
I have several fields on my form that I want to evaluate and show the result on the form. I am trying to create a database tp keep track of my sport cards.

Price Paid
Value when acquired
Current price

What I want to happen is have evaluate the 3 prices, and lt me know if my investment was/is worth it. Is it possible and how do you do it?
Thanks,



For example,

 

[AWithers]

what you need to do is set the control source of a text box to be equal to the releavnt formula involving the three other fields on the form

e.g. ([field2]-[field1])+[field3]

where field1 etc. is the name of the control on the form

Andy