Append Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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)?
 
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.)
 
Back
Top