Please help me with this problem

[richardplr]

Hi.

I select those without check at the logical field to be print but it print some of the check logical field also.

I not very good at coding, what other code do I need to add. Please help.



I have attached a sample for easy understanding. You may use Biogen as supplier, then you can see the different.

Thank you

 

[GabrielR]

Hi.

I select those without check at the logical field to be print but it print some of the check logical field also.

I not very good at coding, what other code do I need to add. Please help.



I have attached a sample for easy understanding. You may use Biogen as supplier, then you can see the different.

Thank you

If I understand you correctly, you need to print the records that have the checkbox received unchecked, is that right?

You need to base your Report on a query that select the records that have No on that field, and criteria to select only the records for the supplier on the screen. As I told you this can go on the query of the report.

I Also sense some normalization problems in your table... When you see so may repetitions in a table (Supplier) you can use one or two more tables and some relatioships between them ....

I added the query for the report... Let us know if I am misunderstanding your question.