repeating values

[TeresaE]

My table has the following fields

ItemNo Name Image DateRecd
123 Foo 00 1/1/06
123 Bla.01 2/1/06
123 Foo 00FOO.jpg 10/11/06
123 FOO FOO 123.jpg 7/5/04
456 bar 00456.jog 6/10/06
456 BAR 00BAR.jpg 7/5/00
456 Bar BAR456.jpg 11/23/06

This is a simplified example of what I need. How would I write / get a query
to run and show me, the two unique items numbers 123 and then 456, but only
the recordset with the most current dateRecd? So for 123 I would want the
10/11/06 date received and then itemno 456 with the date received 11/23/06

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article explains 4 approaches.