Value out of range error

[mogwaicat]

While trying to print a Crystal report in a VB program using an Access query (whew!) I got the following:
ODBC Error: [Microsoft][ODBC Microsoft Access Driver]Value out of range on column number 4 (Employee_IncorTotWage). There are no limitations set on this field in Access as far as a range of values. If I set this field to zero (via Access) and try it again I get a nasty Invalid Descriptor Index error. What's the deal? Thanks!

 

[UncleJack]

Does the value that's out of range refer to a field in a table? If so, do you have an long integer value when trying to display a floating point number? Do you have the value assigned to a variable that declared improperly such as integer when you intend single? Is the destination field dimensioned correctly for the variable you're passing to it?

Uncle Jack