In access how do I calculate a field and also enter in info?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using this formula ([FOB+AdditionalFee])*.05. In my form view I want to
be able to just insert zero instead of doing the calculation. Is this
possible?
 
You want to insert zero instead of doing the calculation under what
circumstances?

Put an if statement in there to display either zero, or your calculated
value based on the result of your IF statement.
 
You may want to put the formula in the default value property.
This should give you the value when the form is opened but also give you the
ability to enter your own value.
The downside to his approach is that you will need some mechanism in place
(i.e. a button) to calculate the formula again if you need to regain the
value AFTER changing the intial value.

HTH

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/
 
Back
Top