Results 1 to 3 of 3
  1. #1
    4am is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    4

    Help on expression that adds together sums and counts of fields

    I have a table called RAWIB



    I want to build an expression that does the following from items in the RAWIB table:

    take the SUM of 'itema' + the SUM of 'itemb' + the COUNT of 'itemc'

    I am very new to access. Is this expression possible? Or do I have to do all the counts and sums in individual queries??

    Thank you for your help!
    -Heather

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,602
    Maybe, could you show sample - field names and example values?

  3. #3
    4am is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    4
    I figured it out using SQL. Thanks!

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

Similar Threads

  1. sql for grouping and counts
    By TheShabz in forum Queries
    Replies: 2
    Last Post: 11-04-2010, 02:01 PM
  2. Clicking on Form Background Adds New Record?
    By swimmermx in forum Forms
    Replies: 3
    Last Post: 08-03-2010, 12:14 PM
  3. Clicking on label adds new record?
    By swimmermx in forum Forms
    Replies: 1
    Last Post: 07-25-2010, 07:03 AM
  4. Replies: 2
    Last Post: 06-20-2010, 06:48 AM
  5. Replies: 0
    Last Post: 06-23-2009, 03:01 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