Append Queries

[Guest]

Dear Sirs
I have a table with 10 fields and a checkbox (yes/no).
I created an Append Query to add those fields to a destination table which
has more fields than the original table.
Access is telling me always that some values are (0) and no record is
appended.
Can someone tell me what I am doing wrong?

 

[Allen Browne]

There could be several reasons why the append fails.

For an explanation of where to look to solve the common issues, see:
Why can't I append some records?
at:
http://allenbrowne.com/casu-19.html

 

[Guest]

Just to be shure Allen,
Is it from the principle possible to append less records from a origin table
to a destination table (with more record fields in)?

 

[Allen Browne]

Not sure I follow that question.

Your source table has fewer records than the destination, but the
destination table has more fields than the source?

The append will append one record for each record you selected in the source
(assuming the new records are not rejected), and values will be added only
to the fields that match unless you have default values assigned on the
other fields.)