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 TouchToneTommy 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: *

  • Users: cdg15
  • Content: Threads
  • Order by date
  1. cdg15

    Select

    Hi A simple one I'm sure. How do I select all records from one table that do not have a FK in another. EG Table_Class ClassID ClassName TeacherID Table_Teacher TeacherID Name I want to see a list of Teachers who are not assigned to a Class. Thanks in advance
  2. cdg15

    Average Query

    Please can someone help. How do I calculate the average date of birth in Access. EG This gives me DOB and Age in years, how do I get the Average Age of ALL users?: SELECT Pupil.DOB, DateDiff('yyyy',[DOB],Now()) AS Age FROM Pupil; Many Thanks C

Part and Inventory Search

Back
Top