F
Frank
I'm having a problem running a query using a text file (pulled from an
AS400) and a DBF file (pulled from an external application). The
fields I want to match are account numbers. In the DBF file, it's a
text field, 25 characters, and the input is all left-justified. In the
text file, the field is 16-characters, and the numbers are all right
justified. All the account numbers contain nothing but digits.
I've tried comparing the Trim() of the numbers and get no matches.
I've tried a query creating an expression using the Val() of the
numbers then querying on that, and I get a data type mismatch. I'm
comparing numbers to numbers, but what the hey; I'm obviously a novice.
Any suggestions would be appreciated.
AS400) and a DBF file (pulled from an external application). The
fields I want to match are account numbers. In the DBF file, it's a
text field, 25 characters, and the input is all left-justified. In the
text file, the field is 16-characters, and the numbers are all right
justified. All the account numbers contain nothing but digits.
I've tried comparing the Trim() of the numbers and get no matches.
I've tried a query creating an expression using the Val() of the
numbers then querying on that, and I get a data type mismatch. I'm
comparing numbers to numbers, but what the hey; I'm obviously a novice.
Any suggestions would be appreciated.