Expression in Queries

[Terri Hdokins]

I have a field in a query called RanchPlot. I would like to have an expression that if there is an X in the RanchPlot field to put in Wide Bed and if not give me Conventional.

Thank you for your help in advance.

Terri Wahlberg

 

[Terri Hdokins]

Fixed It

I figured it out.

Thanks,

Terri

exp: IIf([RanchPlot] Like "*X*","WideBed","Conventional")