Most recent date

[Steve]

I have a databse tracking container movements. I am happily recording
each movement and the date of movement and can see where each
container is by sorting by date of movement. Is there a way I can
produce a query which would show, for each container, only the most
recent move

[Linq Adams via AccessMonster.com]

In Design View for the query, select View - SQL and paste this in,
substituting
your actual object names for ContainerID , MovementDate and
ContainerTrackingTable

SELECT ContainerID AS Expr1, Max(Movementdate) AS max_date
FROM ContainerTrackingTable
GROUP BY ContainerID;

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1

[Steve]

On May 17, 10:56*pm, "Linq Adams via AccessMonster.com" <u28780@uwe>
wrote:

In Design View for the query, select View - SQL and paste this in,
substituting
your actual object names for ContainerID , MovementDate and
ContainerTrackingTable

SELECT ContainerID AS Expr1, Max(Movementdate) AS max_date
FROM ContainerTrackingTable
GROUP BY ContainerID;

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2008...

Thank you - works like a charm

[Linq Adams via AccessMonster.com]

Glad to help!

Steve wrote:

>On May 17, 10:56 pm, "Linq Adams via AccessMonster.com" <u28780@uwe>
wrote:

>In Design View for the query, select View - SQL and paste this in,
substituting

[quoted text clipped - 11 lines]

>>
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2008...

Thank you - works like a charm

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com