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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by tiredmom911
-
Access 2000 Newby needs help with Most Recent Date
Let me ask the question a different way. I can run a query that gives me the most recent date of TB test - SQL is as follows: SELECT [Main EE Data 3-2-09].RC, [Main EE Data 3-2-09].Org, [Main EE Data 3-2-09].EmpNum, [Main EE Data 3-2-09].EmpName, [Main EE Data 3-2-09].PosTitle, [Main EE Data...- tiredmom911
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Access 2000 Newby needs help with Most Recent Date
Thank you so much for responding. I am getting "Syntax error in From clause" message. This is what I used: SELECT * FROM Historical TB Data I INNER JOIN (SELECT EE#, MAX(Given) As LastTest FROM Historical TB Data GROUP BY EE#) D ON I.EE# = D.EE# and I.Given = LastTest Any idea where I...- tiredmom911
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Access 2000 Newby needs help with Most Recent Date
Hi, I apologize for asking a questiong that seems to have been answered here previously, but in SQL form. It has been a long time since I've done anything in Access though so I need help. I have two tables, a main employee table with the primary key being Employee ID and an immunization...- tiredmom911
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
