IIF Not Fully Working. Please Help!

[BigCat]

Right now I am trying to take a couple fields from one of my tables and then use an IIF statement to fill some data into a third empty field, but right now when I run it all it just puts the entire IIF Statement into that third field.



[PROD LINE] : iif([LONG MODEL]="LT*" OR "LD*" OR "ST*", "REFUSE", "")

[orange]

Well the syntax is wrong. What exactly do you want?

Syntax wise you would need something like this

[PROD LINE] : iif([LONG MODEL]="LT*" OR [LONG MODEL]= "LD*" OR [LONG MODEL]= "ST*", "REFUSE", "")

The asterisk has a special meaning in Access under
some conditions. Usually you would use an asterisk * when you are looking for
any character. Like "c*" to get to "cow", "cat","candle"

Do you really have an * in the field? Could [Long Model] actually have the value "LT*"?

[BigCat]

The LONG MODEL field has different truck model numbers and I am trying to put into the database what type of truck it is and that is determined by the first two letters, so that is why I wanted to use the * so it didn't matter what the rest was it would only look at the first two characters.

I just copied and pasted in what you said but it keeps just throwing the entire IIF statement code into my PROD LINE field and for some reason it changes all of my "" into []

[orange]

A couple of points and you've probably heard these before.

Field names with embedded spaces and/or special characters will come back to bite you.
If you have the option, get rid of them.

Instead of this

[PROD LINE] : iif([LONG MODEL]="LT*" OR [LONG MODEL]= "LD*" OR [LONG MODEL]= "ST*", "REFUSE", "")

Try
[PROD LINE] : iif(Left([LONG MODEL],2)="LT" _
OR Left([LONG MODEL],2)= "LD" _
OR Left([LONG MODEL],2)= "ST", "REFUSE", "")

This will compare the 2 leftmost characters...