How can I get the latest date and the relevant columns in an access query.
My Data is in a similar format to this.
Number Supplier Country ExpiryDate A B C D E F G
4049929726987 W RSA SA 19-Jul-19 No No No No No No No
4049929726987 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 12-Mar-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 05-Mar-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 26-Feb-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 19-Feb-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 12-Feb-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 19-Jul-19 No No No No No No No
4049925626325 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 12-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 05-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 26-Feb-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 19-Feb-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 12-Feb-19 Yes Yes Yes Yes Yes No Yes
But when I run my query it gives me this as a result.
Number Supplier Country ExpiryDate A B C D E F G
4049929726987 W RSA SA 19-Jul-19 No No No No No No No
4049929726987 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 19-Jul-19 No No No No No No No
4049925626325 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
But I only want the 19 July rows. How can I go about this, I have tried putting the expiry date to Max and the A, B, C, etc columns to Last but that didn't work because it was giving the last references for a different row.
Any help would be appreciated
My Data is in a similar format to this.
Number Supplier Country ExpiryDate A B C D E F G
4049929726987 W RSA SA 19-Jul-19 No No No No No No No
4049929726987 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 12-Mar-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 05-Mar-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 26-Feb-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 19-Feb-19 Yes Yes Yes Yes Yes No Yes
4049929726987 W RSA SA 12-Feb-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 19-Jul-19 No No No No No No No
4049925626325 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 12-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 05-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 26-Feb-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 19-Feb-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 12-Feb-19 Yes Yes Yes Yes Yes No Yes
But when I run my query it gives me this as a result.
Number Supplier Country ExpiryDate A B C D E F G
4049929726987 W RSA SA 19-Jul-19 No No No No No No No
4049929726987 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
4049925626325 W RSA SA 19-Jul-19 No No No No No No No
4049925626325 W RSA SA 19-Mar-19 Yes Yes Yes Yes Yes No Yes
But I only want the 19 July rows. How can I go about this, I have tried putting the expiry date to Max and the A, B, C, etc columns to Last but that didn't work because it was giving the last references for a different row.
Any help would be appreciated