Hi
First post!
I am new to Access so forgive me if what I am asking is really basic.
I have a form which allows the user to add in some basic info (eg First Name, Surname) and also a series of check boxes. Each check box relates to a test (test 1, test 2, etc).
I have set up a couple of queries:
- Query 1 will show the basic info plus Tests 1 & 2.
- Query 2 shows the basic info plus Tests 3 & 4.
I want to filter it so that if the user checks boxes for Test 1 and/or Test 2 then this data appears in the Query 1 table, but not in the Query 2 table as these tests were not requested/checked.
Thanks in advance.