G
Guest
Hello
This seems simple I but cannot figure out how to make it work.
I am trying to make a query with 2 columns. 'Record ID' and 'Reference
Record ID'.
Record ID is of a variable length and comes from my Table.
Reference Record ID is the Record ID with a suffix character removed if it
is either a D, P, or Z.
Should look like this.
Record ID Reference Record ID
0012345 0012345
0123456D 0123456
0123456 0123456
12345Z 12345
02CC993P 02CC993
It is probable that some of the IDs will have duplicates once the suffix is
removed and that is fine.
Any help will be appreciated.
This seems simple I but cannot figure out how to make it work.
I am trying to make a query with 2 columns. 'Record ID' and 'Reference
Record ID'.
Record ID is of a variable length and comes from my Table.
Reference Record ID is the Record ID with a suffix character removed if it
is either a D, P, or Z.
Should look like this.
Record ID Reference Record ID
0012345 0012345
0123456D 0123456
0123456 0123456
12345Z 12345
02CC993P 02CC993
It is probable that some of the IDs will have duplicates once the suffix is
removed and that is fine.
Any help will be appreciated.