AnsweredAssumed Answered

Find Criteria using 3 fields in table

Question asked by LWayne_1 on May 2, 2012
Latest reply on May 3, 2012 by LWayne_1

Title

Find Criteria using 3 fields in table

Post

Hi -

 

When performing a find in manual mode, the find works fine.  However when I enter it "Enter Find Mode" in script it does not work.

Field one is a number and it works.

Field two is a number and it works.

FIeld three is text and I am looking for blank records.  In the manual find I enter > " " and it gives me the records I want, however in the script it finds no records.

I believe the problem is with the > operator and not having the proper quotes or brackets around it.  However nothing I tried has worked.

I have entered the criteria for each of the three fields in "Enter Find Mode".  I have also used Insert Operator inserted the > operator and then added " ".

Can someone tell me what changes I need to make?

 

 

Outcomes