[VBA] Select when min value is not 0

Thu, 23 Oct 2014 10:55:06 GMT

hi guys

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

then I have Chart table with calculated field

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?

Re: [VBA] Select when min value is not 0

Thu, 23 Oct 2014 11:02:56 GMT

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

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?