Sunday, August 05, 2012 11:31 PM
I have a table with several fields. I want one field to be a calculation based on other fields. I guess i need to select calculated as my data type in this field?
These are the fields i have for example:-
Field A - Currency
Field B - Number
Field C - Number
Field D - My Field in which i want the calculation
The expression if i am using the right word that i want in field D is along the lines of as follows:-
Field D = Field A * Field B if Field B is > Field C if Not use Field C as the multiplier.
I am new to access and have no experience at all so please be patient with me i would apreciate if anybody knows the correct way to make the expression i am after.
Monday, August 06, 2012 12:11 AM
I wouldn't use a calculated field in the table for this. You can perform the calculation in a query based on the table: add a calculated column
Field D: [Field A]*IIf([Field B]>[Field C],[Field B],[Field C])
Regards, Hans Vogelaar
Monday, August 06, 2012 12:47 AMexpression works exactly as i wanted it too thanks a lot.