Text query before comma if any

[geocan2006]

Hi,
I have a query column which has a text , it may contain words with or without a comma, in the example below I need that it results 1st text string before comma if any or not
Thanks

Color	1st color
Green, Yellow, Red	Green
Yellow, Red	Yellow
Red	Red

[June7]

Try:

Left([Color] & ",", InStr([Color] & ",", ",")-1)

[isladogs]

Try:

Left([Color] & ",", InStr([Color] & ",", ",")-1)

The & "," is superfluous. More simply it's

Left([Color],Instr([Color],",")-1)

[June7]

Did you try it? It will fail if the comma is not present because InStr() returns 0 and then -1 will error in the Left().

[isladogs]

Did you try it? It will fail if the comma is not present because InStr() returns 0 and then -1 will error in the Left().

Apologies. Only half awake here.
Of course you are correct. In my version, the final record would fail.

There are alternatives which involve checking if a comma exists but that makes the solution more complex.
Your solution does work for all records

[geocan2006]

Yess, It Worked.

Left([Color] & ",", InStr([Color] & ",", ",")-1)

Thank you