Append Query

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

Guest

I try to append records from table1 into table2 using an Append Query. Even I
have 2 numeric records in table1, I receive the message: "You are about to
append 0 row(s) ". Can anybody help me, please?
 
If you say "Yes" and let it post, it will then give you a longer
message that will describe all the ways in which Access will NOT append
the records. Next to each reason will be the number of records that
were NOT append for that reason.

Once you get that information we can figure out what is happening.
Untill then we really can't help much.

Ron
 

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

Update or Append Query in Access 2003 2
Help with append query 4
append query 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
join keeps cascading 2
UnMatched Query 2
Set (9) fields to Null due to type conversion failure !!!! 2
Append query 4

Back
Top