I have a situation at work where I have a query based on a couple of tables and a report based on the query. I've attached a sample database of what I have, and when the report is run, it sums the quantity in the query for each of the headers. What I want to do is have some kind of an if statement that says if the Electric Awning is checked on Table1, add only the E12' Awning and if is not checked add only the 12' Awning. Can this be done? Sorry, I'm a new user to access and have been tasked with figuring out how to do this. I appreciate any help.