Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Need help with grouping

    I am stuck and need help!

    I have a query with the following fields: CaseNo; DraftNumber; and DraftAmount. I want to run a query that will list the Case Numbers per dollar grouping (as noted below):

    $0 - 24.99
    $25 - 249.99
    $250 - 749.99

    Any suggestions would be greatly appreciated.


  2. #2
    Join Date
    Sep 2003
    Can we assume that you're bucketizing the DraftAmount itself? A way to do this would be to add another column to your query that assigns a "group" number for each draftamount ... Say like:

    IIF(DraftAmount>=250,3,IIF(DraftAmount>=25,2,1)) AS ReportGroup

    Then establish a Group Header/Footer on that column for your titleing ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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