I am having a difficult time trying to figure out how to do this and could use some help...
I have a table that contains a member's last name, first name, and date of birth.
This table gets populated by another source that I have no control over and sometimes a couple of
the records need to be combined. For example:
[pre]
Last First DOB
Smith John 12/1/63
Williams
Kyle 4/21/66
Jones Bob 5/6/65
Johnson
Steve 7/11/66
[/pre]
In this case I would look through the table for records with Last Names without First names and combine this
record with the next record found without a last name into one record.
I would find the last name Williams (which is missing the first name) and then the next record missing the
first name which is Kyle and combine those into one record:
Williams Kyle 4/21/66
and then off to find the next occurrence to combine:
Johnson Steve 7/11/66
So the end result table would look like this:
[pre]
Last First DOB
Smith John 12/1/63
Williams Kyle 4/21/66
Jones Bob 5/6/65
Johnson Steve 7/11/66
[/pre]
Thanks!
I have a table that contains a member's last name, first name, and date of birth.
This table gets populated by another source that I have no control over and sometimes a couple of
the records need to be combined. For example:
[pre]
Last First DOB
Smith John 12/1/63
Williams
Kyle 4/21/66
Jones Bob 5/6/65
Johnson
Steve 7/11/66
[/pre]
In this case I would look through the table for records with Last Names without First names and combine this
record with the next record found without a last name into one record.
I would find the last name Williams (which is missing the first name) and then the next record missing the
first name which is Kyle and combine those into one record:
Williams Kyle 4/21/66
and then off to find the next occurrence to combine:
Johnson Steve 7/11/66
So the end result table would look like this:
[pre]
Last First DOB
Smith John 12/1/63
Williams Kyle 4/21/66
Jones Bob 5/6/65
Johnson Steve 7/11/66
[/pre]
Thanks!