Trim data to a new column

[phamyh]

I have a field with data and I want to take what's left of a comma to a different column. How should I write this formula?

Example: band, the => band

Thanks

 

[Brianwarnock]

You asked exactly the same question in Excel, which software are you using?

Brian

 

[phamyh]

I'm using both. I don't know how to do this in Access either.

 

[Brianwarnock]

lookup Instr in help.

Brian