Calculated field shows in form, by not in my table

chablups

Registered User.
Local time
Today, 12:33
Joined
Feb 2, 2002
Messages
88
I enter a sale price and then in another field, a percentage commission received. I have another field that automatically calculates the dollars received based on the commission. This calculated amount shows on my form, but not on the table, and therefore it does not show on my reports. Why is it showing on my forms, but not in my table? How can I fix this? This is something new, because I have not had this problem before, all of a sudden the calculated field stopped showing up in my table. Did I acccidently hit the wrong button or something?
 
You shouldn't store the result of a calculation, one of the reasons is the result your now experiencing. Repeat the calculation on the report or use a query.

[This message has been edited by Rich (edited 04-02-2002).]
 

Users who are viewing this thread

Back
Top Bottom