Hello!
I am doing a MS access project and I don't seem
to be able to make the result in one of my field dependent on the result of three other fields..
I am using ms access 2007
I need my field 'total cost' to be dependent on whether my other fields(boolian: yes/no) are enabled/disabled
(If field1 is 'Yes', the total cost should increase by 1000 else it is not affected)
(If field2 has 'Yes', the total cost should increase by 1500 else it is not affected)
(If field3 has 'Yes', the total cost should increase by 200 else it is not affected)
I will greatly appreciate any help given
I am doing a MS access project and I don't seem
to be able to make the result in one of my field dependent on the result of three other fields..I am using ms access 2007
I need my field 'total cost' to be dependent on whether my other fields(boolian: yes/no) are enabled/disabled
(If field1 is 'Yes', the total cost should increase by 1000 else it is not affected)
(If field2 has 'Yes', the total cost should increase by 1500 else it is not affected)
(If field3 has 'Yes', the total cost should increase by 200 else it is not affected)
I will greatly appreciate any help given
Last edited: