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
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