Ok I am fairly new to access, I will try to explain this fully... keep in mind my wording will be pretty bad.
What I have is a form on this form there are 5 reports that the user can generate, Eurobodalla, Shollhaven, ACT etc.etc
what I want to be able to do is filter these queries into what job type is in the table, each of the job types are in the table headers with the value being true/false depending on what has been entered for the rows = names of people.
I am not to sure how to do this but it will save huge amounts of time please help.
What I have is a form on this form there are 5 reports that the user can generate, Eurobodalla, Shollhaven, ACT etc.etc
what I want to be able to do is filter these queries into what job type is in the table, each of the job types are in the table headers with the value being true/false depending on what has been entered for the rows = names of people.
I am not to sure how to do this but it will save huge amounts of time please help.