M
mohd21uk via AccessMonster.com
I have a table where I have a list of users and dates. I have created unique
codes which are used to identify a project. These codes are used by these
users to add time to. I have a field called code and a field called date. I
would like to pick up the last date that time has been added to the code. I
have provided an example below to illustrate this:
Code Date
GB2-E0002.02 12/06/2006
GB2-E0002.02 12/07/2006
GB2-E0002.02 15/06/2006
GB2-E0002.02 18/06/2006
GB2-E0002.02 19/06/2006
GB2-E0002.02 20/06/2006
GB2-E0003.02 01/07/2006
GB2-E0003.02 02/07/2006
GB2-E0003.02 03/07/2006
GB2-E0003.02 05/08/2006
I would like to query to provide me with :
GB2-E0002.02 12/07/2006
GB2-E0003.02 05/08/2006
Many Thanks
codes which are used to identify a project. These codes are used by these
users to add time to. I have a field called code and a field called date. I
would like to pick up the last date that time has been added to the code. I
have provided an example below to illustrate this:
Code Date
GB2-E0002.02 12/06/2006
GB2-E0002.02 12/07/2006
GB2-E0002.02 15/06/2006
GB2-E0002.02 18/06/2006
GB2-E0002.02 19/06/2006
GB2-E0002.02 20/06/2006
GB2-E0003.02 01/07/2006
GB2-E0003.02 02/07/2006
GB2-E0003.02 03/07/2006
GB2-E0003.02 05/08/2006
I would like to query to provide me with :
GB2-E0002.02 12/07/2006
GB2-E0003.02 05/08/2006
Many Thanks