 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / August 2006Append Queries
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? 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  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Dear Sirs > I have a table with 10 fields and a checkbox (yes/no). [quoted text clipped - 3 lines] > 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)? > There could be several reasons why the append fails. > [quoted text clipped - 10 lines] > > appended. > > Can someone tell me what I am doing wrong? 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.) SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Just to be shure Allen, > Is it from the principle possible to append less records from a origin [quoted text clipped - 16 lines] >> > appended. >> > Can someone tell me what I am doing wrong? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.