Trim after dashes

[geocan2006]

I have a variable text string, I need to trim all the text after dash , presently my expression: Left([Model],InStr([Model],"-")-1) but it returns #Func! if doesn't find any



Table1

Model

Red-1

Red-2

Red

Yellow

Yellow-2

Want a query results like in below
Query

Red

Red

Red

Yellow

Yellow

Thanks

[isladogs]

Use an IIf statement

IIf(Instr([Model],"-")>0,Left([Model],InStr([Model],"-")-1),[Model])

[geocan2006]

Thanks,