Im trying to set up a Query that will give me the lastest date entered for a particular serial number. My table is set up like this:
Serial # | Date |
610 13-jan-00
620 13-jan-01
630 10-aug-03
610 10-aug-04
620 11-jan-06
620 01-feb-06
The results I want is:
610 10-aug-04
620 01-feb-06
630 10-aug-03
Do I have to have two separate databases? or insert SQL code? Im familar with access however just learning SQL code. Any help would be greatly appreciated!! Thanks!! :?