Numeric field overflow

[carolyn walsh]

I am working with three append queries, which allow me to append data from three smaller tables into a larger table, then create a report. Two of the three queries work just fine, but the third keeps generating an error "Numeric field overflow. (Error 3349) - The data in a Btrieve field is too large to represent in your application."

I have validated that the fields in both tables have the same data types (text, number, etc.), as well as field size. This has me perplexed - can anyone help me figure out why I am getting this error?

If not, is there a better way to combine multiple tables into one report?

 

[Rich]

Use a Union query or sub reports