I have a query that gathers data from 2 tables. Table A contains a part number. Table B contains revision letters. So. . .for every part number, there may be 3 revision letters.
Example:
Table A
123456
123457
123458
Table B
123456 A
B
123457 A
B
C
123458 A
B
C
D
The query simply pulls data from Table A (the part number) and Table B (the revision letter). I want the query to show only the latest revision letter for each part number.
HELP! I'm really hoping someone can help. It's probably a simple solution of which I can't figure out!
Thanks in advance,
mslieder :wink: