Calculated Field in a table - Not working?

thudson

Old Programmer
Local time
Today, 23:53
Joined
Apr 29, 2011
Messages
68
I am developing a database to track my items on eBay. I have 3 fields that calculate the total fees I pay to eBay - Insertion Fee + Final Value Fee + PayPal Fee. I created it using the Expression Builder as instructed when I created the new field, but after saving the table and checking the new field there are no values in the calculated field.
I have Office 365.
Why am I not getting the calculated values?:banghead:
 
Do any of the fields involved in the calculation have null values?

Null + Almost Anything = Null

Make sure you have 0 as a default value in the source calulation fields
 
there are no values in the calculated field.

Are you saving the calculated value in a table? If so, I'd not do that. You can always calculate these values for display purposes. Unless you have an auditory reason to keep them you should NOT be saving them.
 
I found why it was not displaying a value!
I had not set the Result Type and the Decimal places.
Did not realise not doing that would result in displaying nothing!
 

Users who are viewing this thread

Back
Top Bottom