B
Brian McGuire
Hi,
I am new to using access, and have a question about filters. I created a query and it lists data from more then one system that I am working on, i.e. system02, system08, etc. I want it to display just one system at a time, and figured filters would be the easiest way to do this. Basically, in the end I would like a different query for each system. I could easily accomplish this if when I opened up one of the queries the filter was automatically applied, as opposed to having to reapply the filter every time the query is opened. Is there a way to have the filter do this? If not, is there a relatively simple way for me to create a query that displays only data from the desired system? Thanks in advance, best wishes.
Brian
I am new to using access, and have a question about filters. I created a query and it lists data from more then one system that I am working on, i.e. system02, system08, etc. I want it to display just one system at a time, and figured filters would be the easiest way to do this. Basically, in the end I would like a different query for each system. I could easily accomplish this if when I opened up one of the queries the filter was automatically applied, as opposed to having to reapply the filter every time the query is opened. Is there a way to have the filter do this? If not, is there a relatively simple way for me to create a query that displays only data from the desired system? Thanks in advance, best wishes.
Brian