Append Queries

G

Guest

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
 
P

Pat Hartman \(MVP\)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format a table field 2
Append Queries, table, sql command 4
Append only Null records in table 2
Append Query 11
Append Queries in 2007 5
Problem With Autonumber & Append Query 2
SQL Commands 3
Append query and combo box on the form 1

Top