Y
ymustiregister
Hi,
I have a two tables in access. I am using 2003.
First table is like this
Code,Description
1000,Something
2000,Otherthing
Second table
Code,Comment,Date
1000,Yeah,02/07/07
1000,Blah,04/07/07
2000,No,02/06/07
2000,Other,07/07/07
1000,Blah2,06/07/07
Now when I do a query I want to get a summary of both tables with the
code,description, most recent comment for the code and date.
Therefore the result of the query should be:
Code,Description,Comment,Date
1000,Something,Blah2,06/07/07
2000,Otherthing,Other,07/07/07
Any help would be appreciated.
Thanks.
I have a two tables in access. I am using 2003.
First table is like this
Code,Description
1000,Something
2000,Otherthing
Second table
Code,Comment,Date
1000,Yeah,02/07/07
1000,Blah,04/07/07
2000,No,02/06/07
2000,Other,07/07/07
1000,Blah2,06/07/07
Now when I do a query I want to get a summary of both tables with the
code,description, most recent comment for the code and date.
Therefore the result of the query should be:
Code,Description,Comment,Date
1000,Something,Blah2,06/07/07
2000,Otherthing,Other,07/07/07
Any help would be appreciated.
Thanks.