Greetings. I have an excel database that keeps employee names and assignment counts monthly and ytd. One of the employees has gotten married and changed her name. How can i combine the data from her maiden name to go with her new married name. I'm using cr9 to report the data. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
keeping data together after a name change (marriage)
- Thread starter rickxx
- Start date
From the sound of it, there is no unique Employee # or similar to identify these records.
If you are working on name alone then you could add a formula as follows:
if {table.name} = 'Previous full name' then 'Married name' else {table.name}
This would then amend the affected record to match the new recorded name or else show the original value.
So 'Jane Smith' who marries and becomes 'Jane Brown' would have info populated as:
if {table.name} = 'Jane Smith' then 'Jane Brown' else {table.name}
As a basis for your grouping or totals or both.
'J
CR8.5 / CRXI - Discovering the impossible
If you are working on name alone then you could add a formula as follows:
if {table.name} = 'Previous full name' then 'Married name' else {table.name}
This would then amend the affected record to match the new recorded name or else show the original value.
So 'Jane Smith' who marries and becomes 'Jane Brown' would have info populated as:
if {table.name} = 'Jane Smith' then 'Jane Brown' else {table.name}
As a basis for your grouping or totals or both.
'J
CR8.5 / CRXI - Discovering the impossible
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question