I have an Append Query which is appending data to a table. This is done when
I run a Macro.
The problem is, that all fields are getting transfered to the table correct,
except one field. Instead of putting the value (i.e 62.000,00) in that field
, the field shows (i.e.. 39.000,00). I have no idea where the table get the
data from. The append query is showing the correct values. If the are getting
transferred, that field gets changed.
I already made the query and the table new - with the same result.
Anyone knows how that can happen?
Thanks
Klaus

The problem may be that the destination field is too small. Check the
actual limits for Integer, Long Integer, Single, and Double in help.

"Amateur" <(E-Mail Removed)> wrote in message
news:C66DE02B-1E69-4DA8-AA6F-(E-Mail Removed)...
>I have an Append Query which is appending data to a table. This is done
>when
> I run a Macro.
> The problem is, that all fields are getting transfered to the table
> correct,
> except one field. Instead of putting the value (i.e 62.000,00) in that
> field
> , the field shows (i.e.. 39.000,00). I have no idea where the table get
> the
> data from. The append query is showing the correct values. If the are
> getting
> transferred, that field gets changed.
> I already made the query and the table new - with the same result.
> Anyone knows how that can happen?
> Thanks
> Klaus