Return just part of a value

[Anthony Viscomi]

I would like to just return part of a value contained within a field from my
query.

Example: NAGGY,JACOB A

I only want the value up to the comma; how would I achieve this?

Thanks!
Anthony

 

[Rick B]

Do a search. This is asked all the time. You will need to use the MID and
INSTR functions.

 

[fredg]

I would like to just return part of a value contained within a field from my
query.

Example: NAGGY,JACOB A

I only want the value up to the comma; how would I achieve this?

Thanks!
Anthony

In a query...

LastName:Left([FullName],Instr([FullName],",")-1)