INSTR Help

[scubaman63]

I have a field which contains data separated by commas and I would like to pull the first three data elements and disregard the rest. For example:



The field contains Mike, John, Susan, James, Michael, James, Carol.

I would like to pull Mike, John and Susan placing them in there own fields. I am using Access 2016 and I have tried using the Instr command, but was only able to pull the first and second data elements.

Thanks

[isladogs]

Ah, the dreaded multivalue field. I recommend you get rid of them throughout your database.
Anyway whilst it could be done using Instr it will be messy.

Instead use the Split function.
For further info, see https://analystcave.com/vba-referenc...plit-function/

However, be aware that Split cannot be used in a query. Use VBA instead