Hello.
My table (table1) has a field (RTN) which refers to bank codes made of 9 digits.
The first two digits indicate the country in which clients have their account (Country Code). which can be in a Country different from where they live.
Example: RTN 001111111 - RTN: 112222222 - RTN: 223333333
00 is the country code for US
11 is the country code for Germany
22 is the country code for Spain
Since US is the country of residence of all clients, I have placed a textbox (txt1) on a form (form1) with the digits 00.
My query should search all records that in the first two digits of the field RTN, are not 00, basically are not those in txt1.
Appreciate any help with this query criteria. Thank you
My table (table1) has a field (RTN) which refers to bank codes made of 9 digits.
The first two digits indicate the country in which clients have their account (Country Code). which can be in a Country different from where they live.
Example: RTN 001111111 - RTN: 112222222 - RTN: 223333333
00 is the country code for US
11 is the country code for Germany
22 is the country code for Spain
Since US is the country of residence of all clients, I have placed a textbox (txt1) on a form (form1) with the digits 00.
My query should search all records that in the first two digits of the field RTN, are not 00, basically are not those in txt1.
Appreciate any help with this query criteria. Thank you