this is hopefully straight forward for you guys.
im struggling to get to grips with the select case statement and would really appreciate if
i want to have a field that performs a different calculation for each record
heres what i thought it should look like,
Select Case [quantity] (is this the field that i want the result to appear?)
Case 1
[id]!"1" [fielda] * [fieldb]
Case 2
[id]!"2" [fielda] * [fieldb] / [[fieldc]
Case Else
Wscript.Echo "calc still to be set up for an id"
End Select
please help
im struggling to get to grips with the select case statement and would really appreciate if
i want to have a field that performs a different calculation for each record
heres what i thought it should look like,
Select Case [quantity] (is this the field that i want the result to appear?)
Case 1
[id]!"1" [fielda] * [fieldb]
Case 2
[id]!"2" [fielda] * [fieldb] / [[fieldc]
Case Else
Wscript.Echo "calc still to be set up for an id"
End Select
please help