Results 1 to 3 of 3
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Query total on group (2002 SP-2)

    I'm trying to get the total number of trucks (by type) available on any particular day from any number of carriers. The report generated from this query is returning a separate line for each carrier on each day; I just want the total trucks (by type) for that day irrespective of who the carriers are. Any help greatly appreciated.
    Attached Images Attached Images
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Query total on group (2002 SP-2)

    Delete the AvailableCarrierName from the query.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Query total on group (2002 SP-2)

    <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

    I can delineate all kinds of exuses for having missed that. . .ah, but it is so futile.
    Thank you!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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