Stuck on an expression (1 Viewer)

[sirron]

Currently self learning access 2010 and i am stuck on an expression

i have a a field called "repairitem" that can be one of 3 items
bike-mechanical-electrical

i have another field called "labourrateperhour"
i want an expesssion that will say

if "repairitem" = bike then "labourrateperhour" is $15
if "repairitem" = mechanical then "labourrateperhour" is $20
if "repairitem" = electrical then "labourrateperhour" is $25

thaks in advance for the help

 

[AlexN]

If "repairitem" ="bike" then
[labourrateperhour].Value = $15
else 
If "repairitem" ="mechanical" then
[labourrateperhour].Value = $20
else 
[labourrateperhour].Value =$25
end if
end if

something like that. Not tested.

Check out http://msdn.microsoft.com/en-us/library/752y8abs.aspx
or
http://msdn.microsoft.com/en-us/library/cy37t14y.aspx (another way)

http://msdn.microsoft.com/en-us/library/752y8abs.aspx

 

[smig]

A calculated value should not be saved into a field. They should be calculated when required

 

[sirron]

If "repairitem" ="bike" then
[labourrateperhour].Value = $15
else 
If "repairitem" ="mechanical" then
[labourrateperhour].Value = $20
else 
[labourrateperhour].Value =$25
end if
end if

something like that. Not tested.



sorry for being stupid but how do i enter code like this into access 2010. The code looks exactly what i want

 

[AlexN]

Assuming that you have a data entry form which gives values to your table, you can put this code in the AfterUpdate event of the "repairitem" field. Everytime this field changes value, the "labourateperhour" field's value will change accordingly.
Keep under consideration though, what smig stated beneath.