Results 1 to 4 of 4
  1. #1
    gmccray's Avatar
    gmccray is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    11

    Trying to display OperatorId and corresponding name

    SELECT Sum(AppsChecked) AS TotAppsChecked, Sum((AppsChecked)-(AppErrors)) AS TotAppsCorrect, Round((TotAppsCorrect)/(TotAppsChecked)*100,2) AS PctCorrect,
    Sum(AppErrors) AS TotAppErrors, Round((TotAppErrors)/(TotAppsChecked)*100,2) AS PctErrors


    FROM Stats
    WHERE (((Stats.OperatorId)=[Enter OperatorID]) AND ((Stats.Date) Between [Enter Start Date] And [Enter End Date]));


    Hi,
    I am trying to display the operator ID and the corresponding name with the other data per the above code. Whenever I try I get an aggregation error. I have attached a excel file with two tabs which contains the tables that I am working with. Please help! Thankls!....GOnLineTestBook (2).zip

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    do you have [OperatorId] in the SELECT statement?
    I see it in the WHERE, but not the SELECT. (groupBy)

  3. #3
    gmccray's Avatar
    gmccray is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    11
    I tried to put it in there and kept getting a aggregation error.

  4. #4
    gmccray's Avatar
    gmccray is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2015
    Posts
    11
    Thanks RanMan256, I got the ID, now all I have to do is find a way to bring the name too! Any suggestions?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-24-2015, 02:38 PM
  2. Does not display
    By Thompyt in forum Forms
    Replies: 12
    Last Post: 03-02-2015, 12:49 PM
  3. Display top 25 %
    By Faisal Mobin in forum Queries
    Replies: 2
    Last Post: 12-01-2012, 05:14 AM
  4. Getting a map to display
    By cggriggs in forum Forms
    Replies: 1
    Last Post: 07-13-2011, 06:43 PM
  5. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums