Calcuated field does not return correct values

[David Clasper]

Hi,
i am running the query below to return values if certain conditions are met.
However when the query runs it only returns the values from the credits
table. can anyone see what i am doing worng?

it should return 0.1 if the value = customer or 0 if cancelled or use the
value from the credits table to insert the value into the calcuated field.


CalcCredits: IIf([Job Status]="Customer*",0.1,IIf([Job Status]="Cancelled*",
0,[credits]))

 

[tina]

do the actual values in the fields include an asterisk (*)? or are you
trying to use a Like comparison with the asterisk as a wild card character?
if the latter, then you can't use an equal (=) sign. instead, replace it
with the word Like.

hth