Search results

I have a Query "MPFinal" like this, How to combine this statement in to one query, Thks.

Dear Sneuberg,thank you for your help. I really2 appreciate your great effort in solving my problem. I will try my best in working the real database with another 8 checkbox at least. I will let you know my update.:)

Sorry for making you a bit of confusing. As a matter of fact, i actually made a mistake by typing the "Grade" Field instead of "ScType " Field. Hence, I have made the correction below (the red text). Besides that, when both the checkbox are checked, it only appears two data which is overlapping...

Yes Sir, in case (If all checkbox = False then all records from all Field are shown.) is working. :) But in case (If checkbox (Check0) and (Check2) = True then records that match the value "HighSc" in Field "ScType" and value "Town" in Field "Location" are shown. All match value from both field...

Thanks for reply. I have done the same thing before. But it does not give the desired answer. When both checkbox is checked, only overlap value are shown (disired answer is, all data that match both value are shown). And when both checkbox unchecked, not all value from "tblSourceB" shown, only...

I'm trying to run the following as criteria in an MS access query. Basically what I want to do is: If checkbox (Check0) = True and (Check2) = False, then only records that match the value "HighSc" in Field "ScType" are shown. or otherwise value "Town" in Field "Location" are shown. If...