Results 1 to 4 of 4
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291

    I feel like an idiot not being able to sum these numbers

    I am sure the answer to this is easy but I cant seem to get it. I need to sum a few columns. I have attached pictures of the query I want to sum and here is the SQL code if it is needed.



    SELECT Area.Area, qryDICount.CountOfDI, qryDIInspectionStatus.[Descent Inspection], qryDIInspectionStatus.[Surface Inspection], qryCT_DITypes.[Type A], qryCT_DITypes.[Type A Modified], qryCT_DITypes.[Type B], qryCT_DITypes.[Type A or B Special], qryCT_DITypes.[Type C], qryCT_DITypes.[Type D], qryCT_DITypes.[Type E], qryCT_DITypes.[NDOT Type 2]
    FROM ((Area LEFT JOIN qryDICount ON Area.Area = qryDICount.Area) LEFT JOIN qryDIInspectionStatus ON Area.Area = qryDIInspectionStatus.Area) LEFT JOIN qryCT_DITypes ON Area.Area = qryCT_DITypes.Area
    WHERE (((Area.Area)<>"ALL"))
    ORDER BY Area.ID;

    I have tried using a total query but I dont have anything for it to group by. I tried putting in a variable like Total:"" but that didnt work. All of my other queries have had tables which I could LEFT JOIN to create my row names but now I just want the totals. Thanks for help.

  2. #2
    NassauBob's Avatar
    NassauBob is offline Not THAT Green
    Windows XP Access 2003
    Join Date
    Feb 2010
    Location
    Augusta, GA
    Posts
    61
    Hey bud. Can you tell me which data you are wanting to add together?

  3. #3
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    Each column in the table that I posted a jpeg of. If I can figure out how to do one column I can get the rest.

  4. #4
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291
    No one has an idea of how to get this done?

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

Similar Threads

  1. Newbie Help Account Numbers
    By Eric1066 in forum Access
    Replies: 3
    Last Post: 10-23-2009, 03:59 AM
  2. Random numbers
    By Gator777 in forum Access
    Replies: 3
    Last Post: 08-12-2009, 10:04 AM
  3. Rounded Numbers
    By TundraMonkey in forum Access
    Replies: 3
    Last Post: 08-11-2009, 12:19 PM
  4. Set Numbers equal to each other
    By ygu3 in forum Access
    Replies: 1
    Last Post: 07-16-2009, 07:34 PM
  5. Suming Positive Numbers Only
    By jbarrum in forum Access
    Replies: 5
    Last Post: 04-24-2009, 03:51 PM

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