 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / May 2008Most recent date
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 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;  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 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 Glad to help! >On May 17, 10:56 pm, "Linq Adams via AccessMonster.com" <u28780@uwe> >wrote: [quoted text clipped - 5 lines] > >Thank you - works like a charm SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.