Posted on 2011-05-03
I have 1 table, with historic data. The table contains development tasks. Each task has a unique id (A number).
This means that this table has a record for each change to a task and a time stamp. What i need is to create some statistic numbers.
What i do is i that i finds some criteria like "WHERE Status<7 and Start_Date is null and registration_date<#02/28/2011#"
But these criteria should only be used on the latest record for each development task(the unique number) and within the criteria above.
Can i get some help with creating a query that can do this?