in my sql table got a table name POORDLIN_SQL. Inside this table have a field name ord_no. The format of this field is xxxxxx00 (meaning 6 digit number follow by 2 fixed zero behind).
Below are my VBA code:
dbs.Open "Select item_no from POORDLIN_SQL where ord_no = '" & Me.PORelNo.Text & "' and line_no = 1 "
From the code, Me.PORelNo.Text only read the digit number from SQL, it do not know to add two zero behind. (Meaning ord_no = xxxxxx, not = xxxxxx00)
How can i correct this VBA statement??
Below are my VBA code:
dbs.Open "Select item_no from POORDLIN_SQL where ord_no = '" & Me.PORelNo.Text & "' and line_no = 1 "
From the code, Me.PORelNo.Text only read the digit number from SQL, it do not know to add two zero behind. (Meaning ord_no = xxxxxx, not = xxxxxx00)
How can i correct this VBA statement??