Multiple Criteria (A2K/XP)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote