Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Criteria (A2K/XP)

    Hello All: I have a table with 10 sessions. I'm trying to create a query that will check to see if a person is registered for any or all of the 10 sessions. I created a query but discovered that I can only check for 9 of the sessions. Attached is my example. As always, any and all help is greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Criteria (A2K/XP)

    By default, a query has only a limited number of criteria rows. But you can insert new criteria rows by clicking somewhere in the criteria and selecting Insert | Rows.

    BTW, your table design is not optimal. It would be better to have two tables: a table listing all CamperIDs with details such as Notes, and a second table with a separate record for each session a CamperID is registered for.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Criteria (A2K/XP)

    Thanks Hans for the quick response. A redesign is being considered.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Criteria (A2K/XP)

    See the attached version - the module basConvert contains a macro that can be used to convert the table structure. It assumes that you have created a table tblRegistration with two fields: Camper ID and SessionID. In the attached database the code has already been run.
    The query qryRegistration shows how easy it is to return all Camper IDs that have at least one registration.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Criteria (A2K/XP)

    Hans,
    Once again, Thanks for the quick response and the sample. I will definitely use it.

Posting Permissions

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