Append Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amateur - 21 Mar 2007 17:31 GMT

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

Reply to this Message

Pat Hartman (MVP) - 21 Mar 2007 17:53 GMT

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

>I have an Append Query which is appending data to a table. This is done
>when
[quoted text clipped - 12 lines]
> Thanks
> Klaus

Reply to this Message