filtering query

[109bow]

I'm hoping someone has an answer to the problem I've been given.
In the range column there are multiple entries for the same record, but somehow I need to show the last entry by date for each.
eg 12001-1 has 3 records but I only need to show the one with the latest date. 12006-4 has 4 records and I need the last and so on.
any help much appreciated,

 

[pbaldy]

Does this help?

http://www.baldyweb.com/LastValue.htm

 

[109bow]

thanks your reply, i'm not sure where to put it in my query, below is the SQL, any guidance would be much appreciated

SELECT [car no] & "-" & [axle position] AS joined, [09ts data].[axle serial], [09ts data].Date, [09ts data].KM, [09ts data].[turn description], [09ts data].[ave post wd]
FROM [09ts data]
WHERE ((([09ts data].[car no]) Like "120**"))
ORDER BY [car no] & "-" & [axle position];