Combine Fields

[enjiel]

I'm not sure what the best way to go about this (query or VBA). I've been creating a database to replace a spreadsheet system. I'm at a point where I need a recursive query for member and supervisor.
The problem is that the format isn't the same between the FULL_NAME field (for member) and the SUPV_NAME field. I'd like to develop an in-between query or script to point the SUPV_NAME to the right member.
Ex.
FULL_NAME EMP_ID SUPV_NAME
PRINCE, THE 12955 COBAIN, K
COBAIN, KURT 01882 MARLEY BOB
MARLEY, BOB 00211


The spreadsheet system that we are using isn't well structured, unfortunately... Any ideas on how I might go about this?

[June7]

Without consistency, no easy way to accomplish. You need to fix the data. This could be a tedious, labor intensive effort. Without a valid table of associations, I don't see how this db devlopment can progress.

And I am not really sure what you mean by 'recursive query'. Either there is a valid association of data or there isn't.