[VBA] Select when min value is not 0

[#1]

hi guys

I have a data tables as per example below (0 means that there was no submission)

Partner	month	Number of Working Days
P1	Jul	5
P1	Aug	8
P1	Sep	12
P2	Jul	0
P2	Aug	0
P2	Sep	0
P3	Jul	5
P3	Aug	12
P3	Sep	0
P4	Jul	0
P4	Aug	0
P4	Sep	6
P4	Jul	6
P4	Aug	8
P4	Sep	18

then I have Chart table with calculated field

Partner	Months not received
P1	0
P2	3
P3	1
P4	2
P5	0

So basically I am checking how many months partner does not sent data to us.

I created 2 buttons 1 is to show all partners who does not sent us data at least once.

To do so I simply using action select in filed if value is 0.

Now I need to select all partners who always (in selected pried of time) submitted data.

If I will use same logic as for not submission it will select any partner who submit data at least once (which is incorrect)

Unfortunately I cannot use field "Months not received" as it is caluclated field.

I was trying to make it with set analyses, but without success.

is there a way to do this in VBA? or at least is there is some proper manual for VBA so I can do that by myself?

[#2]

I thought about something like:

Loop "partner"

     if min("number of working days" - "for selected period of time")<>0 then

          ActiveDocument.Fields("partner") .select

     end if

next

yes, yes, I know, this is incorrect code, but it shows the logic that I think can be used there

Or maybe there is a way to use "Months not received" and just filter 0?