Results 1 to 4 of 4
  1. #1
    Daisy509th's Avatar
    Daisy509th is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    Central Texas
    Posts
    51

    Counting Rows and getting totals

    I have a report which list drivers and their trucks. My boss now want on the report the total number of drivers and than also the total number of trucks. I really feel like i am over thinking this and making it way harder than it should be.



    If I have a table with ten drivers and ten trucks how would I count the drivers and trucks to get totals?
    each row of the report contains one driver and one truck which is assigned to him or her.

    Thanks up front for any help!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Reports can sum fields on the report in the footer. They can also count those same fields.

  3. #3
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,004
    Can you post up a picture of some sample data and your expected results ?
    An excel example will be fine
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,973
    Expression textbox ControlSource:

    =Count([DriverName])

    =Count([TruckNumber])

    Place textboxes in report footer section.

    Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 7
    Last Post: 06-02-2015, 09:36 AM
  2. Replies: 2
    Last Post: 04-02-2014, 09:15 AM
  3. Summing/Counting data in rows
    By jgelpi16 in forum Access
    Replies: 6
    Last Post: 01-20-2011, 07:24 AM
  4. New to Access- help with counting rows
    By cip315 in forum Access
    Replies: 5
    Last Post: 03-19-2010, 09:35 AM
  5. Counting rows
    By anishap in forum Access
    Replies: 0
    Last Post: 10-08-2008, 10:41 PM

Tags for this Thread

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