Need some help,it has been a long time

[realdemon]

I used to program in MS Access all the time but that was 15 years ago so the rust has set in.

I need some help.

I want to run a query using three tables but the data in the third table is only used if the checkbox in the second table is ticked (I am using Access 2016) otherwise it should remain blank on the report..



Can somebody help me please, I know it is an easy thing but I cannot remember.

[ranman256]

In the query, join all 3 tbls, in the criteria for tbl2, set true to the check box field.