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!

Register Log in
  • 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!

Search results for query: *

  1. 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...
  2. tiredmom911

    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...
  3. tiredmom911

    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...

Part and Inventory Search

Back
Top