Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    Unanswered: filtering by totalhrs

    I have a db where i am storing studentno. name, proj , nrhrs, addlhrs, totalhrs and moth where more than 1 row for some students for a particular month. now i am finding it difficult to filter by studentno where totalhrs is with is in a range (say 135 to 150 % of nrhrs)in a qry or report where i want have all rows belongs to that studentno

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Look up aggregate functions and the use of the HAVING clause in Books Online.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Apr 2008
    Along the shores of Lake Michigan
    And speaking of moths, did you ever smell moth balls???? How did you hold him??? -- ba da bump - An oldie but still makes me chuckle..

    Anyway, we don't do homework. Put in the effort and show us what you have or where you got stuck and you'll get all kinds of assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts