IFF statement script question

[shin_mitsugi]

I am trying to write an IFF statement that will fill in a specific dollar amount depending on what item has been purchased. For example, if the item is a car, then $1000, if its a truck, then $1500.



I imagined the code to be something like:

IIF([Product]="car",$1000,IIF([Product]="Truck",$1500,""))

However, if I were to type this into ACCESS it doesn't work. Access produces an error that says "you cannot set "price" to the calculated data type." What does this mean and can anybody please write the formula in the way that Access needs it to be written?

Thank you so much!

[June7]

Don't include the $ sign. Also, if this is a number type field then can't use the "" empty string. Use a number or Null.

Where are you using this expression?

[JoeM]

Where are you trying to enter this calculation?
Also, get rid of the $ sign before the number. Currency formatting will take care of that, but you just want a strict number in there, with nothing else.

[snipe]

To summarize what these guys said...

If the "Price" field is a number type:

IIF([Product]="car",1000,IIF([Product]="Truck",1500,null))

If the "Price" field is a text type:

IIF([Product]="car","1000",IIF([Product]="Truck","1500",null))