help with calculated data type in tables

Question

Hi,

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.

Many Thanks

Answer 1

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

Answer 2

expression works exactly as i wanted it too thanks a lot.

---

Nabil Nagar