O
ozlink
Hi All
Hopefully someone can help with the following problem I have.
I have a table which has a list of records and I need to make a change
to the last record in a group. ie every record has a value in field B
of "abc" however in the last record where field A's value is the same
the value in field B needs to be "xyz"
For example
existing data may look as follows
field A Field B
10034 abc
10034 abc
10034 abc
11245 abc
11245 abc
11245 abc
11245 abc
9564 abc
9564 abc
9564 abc
What I want it to end up looking like is the following
field A Field B
10034 abc
10034 abc
10034 xyz
11245 abc
11245 abc
11245 abc
11245 xyz
9564 abc
9564 abc
9564 xyz
Thanks in Adavance
David
Hopefully someone can help with the following problem I have.
I have a table which has a list of records and I need to make a change
to the last record in a group. ie every record has a value in field B
of "abc" however in the last record where field A's value is the same
the value in field B needs to be "xyz"
For example
existing data may look as follows
field A Field B
10034 abc
10034 abc
10034 abc
11245 abc
11245 abc
11245 abc
11245 abc
9564 abc
9564 abc
9564 abc
What I want it to end up looking like is the following
field A Field B
10034 abc
10034 abc
10034 xyz
11245 abc
11245 abc
11245 abc
11245 xyz
9564 abc
9564 abc
9564 xyz
Thanks in Adavance
David