hi guys,
i guess this is a pretty basic query but i can't seem to make any sense of the help function.
i need to create a table that will look up various hourly rates depending on the trade that i type in.
i.e if i have 3 columns- "trade", "hours worked" and "cost of job", the cost of job column will be calculated automatically by looking up the rate for each trade (electrican, joiner, engineer, etc). I have about 10 different trades each with different rates and don't want to have to remeber all 10!
any help appreciated
i guess this is a pretty basic query but i can't seem to make any sense of the help function.
i need to create a table that will look up various hourly rates depending on the trade that i type in.
i.e if i have 3 columns- "trade", "hours worked" and "cost of job", the cost of job column will be calculated automatically by looking up the rate for each trade (electrican, joiner, engineer, etc). I have about 10 different trades each with different rates and don't want to have to remeber all 10!
any help appreciated