The attached file shows two queries. The first qryAllSections is as it says i.e. all the Sections. The second is the Sections showing Junior Exhibitors. This data is from a Form (not included) with a yes/no box. The criteria set to yes in the query to obtain this result. What I would like to do is to set another query that would give me qryAllSections minus qryJuniorNotNull. I.E. just the Sections that contain no Juniors. Setting the criteria of Juniors to Null will not work as because it returns all other Exhibitors therefore all Sections. Lastly each year the sections containing juniors will generally vary so one cannot work from the Sections as shown in this example. Would appreciate any help.
Separating data in two queries
- Thread starter BillBee
- Start date
