Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2016
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Need Help Ranging a Group of Numbers

    Good afternoon,
    I am working in an Access Database where each line of information has a box number, and those box numbers need to be categorized into a range on a report. How can I make that happen?

    For example, if I have 33 lines that each have their own box number (1 through 33), how can I get Access to recognize that and list on my report the following: BOX NUMBERS: 1 - 33 instead of writing them all out? Of course, my query would only calculate those persay 33 boxes based on my need, so that part would be taken care of. It's transferring that information onto my report that has me stumped.

    Thank you.

  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    238
    Thanks
    0
    Thanked 37 Times in 36 Posts
    Welcome!

    maybe use a grouping/totaling query with columns for Min and Max box number
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    New Lounger
    Join Date
    Oct 2016
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I will definitely try that suggestion, thank you.

Posting Permissions

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