I've never had to do this before and my brain is not processing how to get this to work.
I have a query that pulls information based on criteria from several tables. Then I have a simple report that populates a list of information from the query.
Now I have to change the report slightly and only populate specific information based on a new Yes/No check box that was added to a table. So I did a copy of the original report (because I still need the original) and am trying to figure out how to filter for the new report.
I cannot for the life of me wrap my brain around how to get this to work. Is it possible to write something to the way of....
If MachineDPA is True then Show this record on the report.
I was speaking with another Access User that is about as skilled as I am (pretty basic) and they thought I needed to create a brand new query design and use that as my source. The problem is I have a lot of different reports like this that are going to change based on one item or another (not all check boxes). So I was thinking if I could figure out a way to do one of them then I could give a stab at the rest of them.
Thank you for your help.
I have a query that pulls information based on criteria from several tables. Then I have a simple report that populates a list of information from the query.
Now I have to change the report slightly and only populate specific information based on a new Yes/No check box that was added to a table. So I did a copy of the original report (because I still need the original) and am trying to figure out how to filter for the new report.
I cannot for the life of me wrap my brain around how to get this to work. Is it possible to write something to the way of....
If MachineDPA is True then Show this record on the report.
I was speaking with another Access User that is about as skilled as I am (pretty basic) and they thought I needed to create a brand new query design and use that as my source. The problem is I have a lot of different reports like this that are going to change based on one item or another (not all check boxes). So I was thinking if I could figure out a way to do one of them then I could give a stab at the rest of them.
Thank you for your help.