Overwrite Formula on Single record...

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

Guest

Hi there,

I've created a query that calculates as follows:

Months of Lease Amount of Lease Lease Payment
(user enters) (user enters) (query calculates Amount/Months)

Now every once in awhile, the payment is not calculated using the formula and is just chosen as a nice even number with no real formula to it. Is there a way to overwrite the formula for these records?

Much thanks!

Lynndyhop
 
Are you adding a record to a form? IF so, on the OnUpdate event for the
"Amount of Lease' I would enter something like:

[LeasePayment] = [MonthsofLease] * [Amount of Lease]



Then, the user could leave it, or overwrite it before saving the record.

Please be more specific if this does not answer your question. We need to
know if you are pulling data out (in a report or query) or if you are adding
data to a table.


Rick


Hi there,

I've created a query that calculates as follows:

Months of Lease Amount of Lease Lease Payment
(user enters) (user enters) (query calculates
Amount/Months)

Now every once in awhile, the payment is not calculated using the formula
and is just chosen as a nice even number with no real formula to it. Is
there a way to overwrite the formula for these records?

Much thanks!

Lynndyhop
 
Back
Top