sumarize table

[Guest]

I have a table of 6 field ,, the first one is ID ,, and this field is
ferquent many times in the table ,, what I need is to obtain a new table
which include the last recrods for each ID according to the last entry or
last time for the ID,, I make the query and bring the max time and so far its
good, but the problem is in my query ,, i have the correct ID and last time,,
but other fields is incorrect

 

[Van T. Dinh]

You need to use the SubQuery.

See The Access Web article:

http://ww.mvps.org/access/queries/qry0020.htm