Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Unanswered: Access 2007 multiple criteria help

    Hi I have a database that needs to be able to call multiple criteria to show certain labels. Example, enter in multiple job sub sections like G, V, or X and it would list everyone with those job sub sections and not show duplicates of people in multiple sections. Is there a simple way to do this? Thanks.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    It seems to me that you can just feed the outcome of your selections into a totals query, and group by the duplicates.

    Sam

  3. #3
    Join Date
    Feb 2012
    Posts
    2
    Would I use a form to collect the criteria? If so would I just add a button to pass it to the query and then finally the report?

Posting Permissions

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