Results 1 to 1 of 1
Thread: MSQuery numeric range (xl97 )
2006-04-06, 12:32 #1
- Join Date
- Apr 2001
- Warrington, Cheshire
- Thanked 0 Times in 0 Posts
MSQuery numeric range (xl97 )
I have msquery using odbc connection for retrieving data from sql server database.
All has been well with the returns and I have two parameters for the query
First parameter is varChar (it defaulted to that) for client ref - say bd123
Second parameter is numerical and refers to client id - 394550
User enters values on prompt and it HAS worked fine.
However, we have now beached the 5000000 value for client id's and whenever a value over 5000000 is entered then I get an out of range error
BUT......if I edit the query and enter the value of 5000000 directly in the criteria field (instead of [EnterClientID], then the query retruns all of my requested data.
Any any suggestions please.