If statements not working as they should...
I'm working on a database for the company I work for, now i'm to the fun part of writing up various reports that suit our needs. I'm having a problem with my If statement spotting if the qty on my orders are not equal to 0. It seems to omit only every other record regardless of the qty in stock. If i manual change the qty to 0 then it does spot it, but not otherwise.
here is the two scripts i am running for said sort...
Script 1 (START BUTTON FOR CLOSED ORDER SORT)
goto record (first)
perform_script("SORT OPEN ORDERS")
Enter Browse Mode
Show All Records
Second Script(sort open orders)
If (Inventory::DYN_QTY notequal 0)
goto record(next) exit after last
goto layout (original )
IF anyone can think of why this is not performing as it should, any help is appreciated.