expressions

[Guest]

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?

 

[Guest]

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

 

[Brian]

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?

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?

 

[Larry Daugherty]

Move your expression to the control's Default Value property.

HTH