repeating values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TeresaE - 30 Nov 2006 01:27 GMT

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

Reply to this Message

Allen Browne - 30 Nov 2006 03:04 GMT

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

The article explains 4 approaches.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> My table has the following fields
>
[quoted text clipped - 13 lines]
> 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

Reply to this Message