Datatype error

[Guest]

I am using Office 2003 on Windows XP.

I am trying to run a make table query against an Oracle DB into Access.
The following line is causing the problem:

A.FUND BETWEEN '801' AND '999'

When I use: A.FUND = '801' AND
I get no errors.

"FUND" is typed in Oracle as "VarChar2(3)". I suspect my problem is related
to the datatype. I have tried to convert this field in the WHERE clause for
example:

Val(A.Fund) BETWEEN 801 AND 999

But this also fails (with or without single quotes around the 801 and 999.
Can someone please help me crack this conversion issue or otherwise point out
what may be wrong?

Thanks much in advance.

 

[Duane Hookom]

Does this work?
A.FUND >= '801' AND A.FUND <= '999'

 

[Guest]

Thanks Duane, I will give this a try, didn't think of this approach.