Append Queries

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 in 2007 5
Append only Null records in table 2
append query not appending 2
Problem With Autonumber & Append Query 2
Append Query 3
Append Queries, table, sql command 4
Using select query results as filter for append query 14

Back
Top