Selecting tasks with highest weeknumber

[Frantic]

High,

have been searching on this simple problem for a whole day without finding a solution ...

I 've got a query which extracts "task_description" and "weeknumber" out of two different tables. Unfortunately, some tasks which are not completed one week, are re-inserted the next week, so I got this list showing the same tasks with different weeknumbers.
Now, I want my query only to show the tasks and their latest weeknumber.

Can someone tell me how ?

Thx !

 

[cpod]

Just create a totals query on the table with the week number in it. Insert all the fields you will need. All the fields will be "Group by" except the week number field - change that to "Max".

Now use this query to join with your other table.

 

[Frantic]

Thx for replying, but I'm affraid you're going a little too fast ...

As an Access rookie (more experienced in My-SQL) the way these query's are build seems a bit strang to me.

 

[Frantic]

Fantastic ! I solved the problem thanks to your help !