Hello,
I am working on a worksheet where I copy data from an Access database which then I want to sort alphanumerically; as in letters on top and then ascending numerical values.
The query I'm using is:
When I run the code I get a run-time error 'Syntax error (missing operator) in query expression 'IF(PO RLIKE '^[a-z]',1,2,)'
Can somebody help me with this?
I am working on a worksheet where I copy data from an Access database which then I want to sort alphanumerically; as in letters on top and then ascending numerical values.
The query I'm using is:
Code:
SQL = "SELECT Material, Description, Qty, Unit, Amount, Currency, Batch, PO " & _
" FROM " & strTable & " WHERE P_Order = '" & CStr(Calculation_SelectedProcessOrder) & "' " & _
" ORDER BY IF(PO RLIKE '^[a-z]',1,2),PO; "When I run the code I get a run-time error 'Syntax error (missing operator) in query expression 'IF(PO RLIKE '^[a-z]',1,2,)'
Can somebody help me with this?
