Search results

I attached the query for your review

I am trying to place this in a query. [Code] has four possibilities: 1 = 67.50 2 = 50.00 8 = 51.75 10 = 36.00 When 1,2,8 or 10 is placed the Code filed I am trying to populate the rate field with the corresponding number, i.e, 67.50, 50.00, 51.75 or 36.00 Thanks for your consideration.

No, 8 is not the only option. There are multiple options.

I need help with a simple IIF statement. I have two fields, [CODE] and [RATE]. The I would like is if Code=8 then the Rate = 67.50. Can someone help?