Retieve last dates in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frikkie - 23 Apr 2008 19:22 GMT

How do i get the last dates out of a table in a query
My query looks like this
Station Code and set number    Date off inspection
CNC 18    10/11/2005
CNC 18     23/02/2006 1
CNC 19     24/07/2006
CNC 19    24/01/2007 2
CNC 20      07/02/2008 3
CNC 20      16/07/2007

I want to see the dates of no 1 ,2 and 3 in my Query
can you help me please
Thanks

Signature

Reply to this Message

Jeff Boyce - 23 Apr 2008 19:34 GMT

(caution: untested)

One way might be to create a new query based on this table, select the
[StationCode] and [InspectionDate] fields, then click the <Totals> button on
the Toolbar.

The words "Group By" will show up under each field. Change this to "Max"
for the [InspectionDate] field.

This should group all [StationCode] values together, selecting the maximum
[InspectionDate] for each.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> How do i get the last dates out of a table in a query
> My query looks like this
[quoted text clipped - 9 lines]
> can you help me please
> Thanks

Reply to this Message

Frikkie - 24 Apr 2008 17:20 GMT

Thanks Jeff

Signature

> (caution: untested)
>
[quoted text clipped - 26 lines]
> > can you help me please
> > Thanks

Reply to this Message