Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting only the latest date
I don't think this will work. What I'm trying to get is: - Item Description Loc User 1 Item 1 1 Mr X 2 Item 2 1 Mr Y 3 Item 3 5 Mr A etc ..... Each Item will have a number of Rows in the Audit Table, as the purpose of the Audit table is to...- pkin
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Selecting only the latest date
Hi all, I've been trying to work out how I can SELECT only the latest date from a table. I've created an Audit Trail Table in Access and want to report on a form, where the item currently is: I have two tables: Items = ItemNo+ItemDesc Audit= DateTime+ItemNo+Loc+User and I want to see on a...- pkin
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
