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!

Recent content by cdg15

  1. cdg15

    Select

    PHV, Great! I was using = 0 Thank You
  2. 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
  3. cdg15

    Average Query

    Thank you PHV That is exactly what I wanted - I can see where I went wrong now! :) C
  4. cdg15

    Average Query

    Ok this is what I have: SELECT Pupil.DOB, DateDiff('yyyy',[DOB],Now()) AS Age, Avg([Age]) as Avg_Age FROM Pupil group by Pupil.DOB, Age, Avg_Age; On executing it asks me to enter parameter, I justy want to see the average of all their ages? Thanks in advance
  5. cdg15

    Average Query

    Thanks for your comments. I will look at the link you provided. However, regardless of accuracy how do I write the SQL to average the age column?? Thanks
  6. 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
See more

Part and Inventory Search

Back
Top