Not appending correct data

[Guest]

Help! I am going crazy, I have an append query that is appending data from
one table to another. When I run the query as a select query, it shows all
the data I want to transfer, (some dollar amounts). When I run the append it
does not transfer all the dollar figures only some. Any ideas? Thanks

 

[Guest]

Are you receiving any error messages like "5 records not appended due to key
violations"?

Assuming that you might have warnings turned off, does the table where you
are appending data to have a primary key or any unique indexes? See if the
select query has an records that would conflict. These records will not be
appended.

Do you have any input masks or validation rules that might prevent the data
from being added to the table?

Any required fields that are null in the select query?

 

[Guest]

No I did check all that and even re created the table with the query. Just
doesn't seem to want to collect all the information. Thanks

 

[John Vinson]

No I did check all that and even re created the table with the query. Just
doesn't seem to want to collect all the information. Thanks

Care to post the SQL of the query, and any VBA code you're using to
execute it?

John W. Vinson[MVP]