Need to alter column values
Posted on 2011-03-02
Experts, please help in to solve the situation. I will explain with example as what I have and what I need.
ID - is used to distinguish a family records(ex 010 belong to one family)
MS - it is an indicator to know who is subscriber and who are dependents
00 is a subscriber and 01,02,03,04.... are Dependents
FN - First Name
LN- Last NAme
Add1 address 1
Add2 Address 2
req add1 - required address1 is what i need the format as
req add2 - required address 2 is what i need the format as
Id MS FN LN Add1 Add2 Req Add1 Req Add2
010 00 Sam pat 123 XYZ Apt 3 123 XYZ Apt 3
010 01 adam pat 123 XYZ Apt 3 C/O Sam Pat 123 XYZ Apt 3
010 02 eric lank 123 XYZ Apt 3 C/O Sam Pat 123 XYZ Apt 3
( 010 is a family records with subscriber 00 and dependents 01,02 records.Look at Req Add1 for MS = 01 & 02 it should be as C/O FN LN of subscribers)
023 00 Ann coo 235 RMS Suite 3 235 RMS Suite 3
023 01 tan wood 235 RMS Suite 3 C/O Ann Coo 235 RMS Suite 3
(023 is second family records)
and so on I have 1000 family records of these kind.
I am figuring out how to do in Access 2003 as I have table in access database.