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.