Results 1 to 6 of 6
  1. #1
    Kirnicko is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    8

    Splitting Report

    This seems like it should be really easy, but I'm spending a lot of time trying to figure it out. I have a lengthy report of names (200). We will be using these names to check people in to an event. Is there a way to divide the report say A-M & N-Z so that we can have more than one person trying to get everyone checked in? I'm thinking it would be in the query, but I cannot figure out how to do it. Thank you! Am looking forward to learning a lot from this forum. ~kirnicko

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try

    < "N"

    in the last name field criteria.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Kirnicko is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    8
    Thank you!
    I am an impatient person and spent about 3 hours before I tried parameter between 'beginning letter' and 'ending letter'. That worked. But I'll try this as well, since it seems easier. Thanks for the post!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    A parameter query would be more flexible. Most of us use a form to gather user input rather than bracketed criteria like

    [Enter beginning letter]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Kirnicko is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    8
    Well now my noviceness will show because I'm not sure how that would be done. I'm the only one who uses this so I generally don't do forms.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If it's just for you it probably doesn't matter. You'd create a form with two textboxes for the desired inputs and a button to open the report. Instead of a criteria like:

    Between [Blah] And [Whatever]

    you'd have:

    Between Forms!FormName.FirstTextbox And Forms!FormName.SecondTextbox

    You have more control, you can validate the inputs, etc. Like I said, if it's just for you it may not be not worth the bother.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 5
    Last Post: 11-07-2015, 03:53 PM
  2. Replies: 6
    Last Post: 10-22-2015, 06:12 AM
  3. Replies: 6
    Last Post: 11-04-2014, 10:56 PM
  4. Replies: 3
    Last Post: 06-14-2013, 05:47 PM
  5. Replies: 1
    Last Post: 09-25-2012, 01:58 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