Results 1 to 3 of 3

Thread: Query Help

  1. #1
    Join Date
    Apr 2009

    Unanswered: Query Help

    Problem solved, thanks for replying though
    Last edited by Xpirmntl; 04-29-09 at 00:50.

  2. #2
    Join Date
    May 2005
    Welcome to the forums

    First off, I'd encourage you to try to normalize your table design.

    As for your query, could you post what you have so far (the SQL)? That would help us out tremendously.
    Me.Geek = True

  3. #3
    Join Date
    Apr 2009
    As I don't have access(unentended pun) to the database at the moment, due to being at home, i'm not able to give the sql of the query.

    Let me try to explain myself more clearly:

    I'm trying to create a query based off of the project database that includes all fields. The table itself contains multiple projects that each have the same student I.D. (As the primary key is in the base table). I've tried to use the sum function to sum together the total completed hours per student based off every project that corresponds to the student's student I.D. however, i've failed, as instead of summing the hours together per student over all projects, the query continues to show every project without summing anything together.

    So basicly I'm looking for a way to sum the total hours per student using every project the student did over their entire high school career and show only one, totally summed record per student with the sum of total hours in the query.

    I'm not sure if i explained myself any better, but any help you guys can offer would be greatly appreciated

    I'll try to get the sql of the query tomorrow.
    Last edited by Xpirmntl; 04-27-09 at 19:38.

Posting Permissions

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