expressions

T

TK

I have a simple expression in a form that sums three fields, is there a way
that I can keep the expression the way it is but be able to manually enter
information into the summed field? For example, the summed field adds monthly
data to give a quarterly total. However, in some cases I might already have
the quarterly data. Is there a way that I can just input the data into the
field where the expression is and keep the expression for future records?
 
D

dlw

add fields to the form where you input the numbers if you have them, and use
the IIF statement in the sum:

IIF(inputdata=0,calculateddata,inputdata)

this will use the inputdata field if it's not 0, and the other one if it is
 
B

Brian

TK said:
I have a simple expression in a form that sums three fields, is there a way
that I can keep the expression the way it is but be able to manually enter
information into the summed field? For example, the summed field adds monthly
data to give a quarterly total. However, in some cases I might already have
the quarterly data. Is there a way that I can just input the data into the
field where the expression is and keep the expression for future records?
Click to expand...

That sounds a bit bizarre. A calculated control can't be bound to any field
in the database, so what would be the point in typing data into it?
 
Top