M
Mark909
Basically what im trying to do is that if the Object Type in one column
contains different types of objects then a new column called cost will be
updated displayed the cost of the different objects.
I guess itll be somewhere alongs the lines of:
If [Object Type] = "FW2" then [Cost] will equal £300; If [Object Type] =
"FW4" then [Cost] will equal £400; If [Object Type] = "CW2" then [Cost] will
equal £350; etc; etc
Im really new to Access so still trying to get the hang of queries. Will I
need to create a seperate table with the costs of each item time then link it
to create a new query?
contains different types of objects then a new column called cost will be
updated displayed the cost of the different objects.
I guess itll be somewhere alongs the lines of:
If [Object Type] = "FW2" then [Cost] will equal £300; If [Object Type] =
"FW4" then [Cost] will equal £400; If [Object Type] = "CW2" then [Cost] will
equal £350; etc; etc
Im really new to Access so still trying to get the hang of queries. Will I
need to create a seperate table with the costs of each item time then link it
to create a new query?