need help using Access Append Query

[marnold37341]

I am attempting to append records from tableA to tableB using an append query. Fields in tableA and tableB have the same field names, structure etc. TableB has no records. TableA has eight records. When I run the query, no records are selected or moved. I have followed the append query help topic exactly (I think). The query seems to have no errors, but nothing copies over.

Any ideas on what is wrong??

Mickey Arnold
marnold37341@yahoo.com

 

[dannyocean]

Set some criteria that all of your data would meet.

Example First_Name is not null

Try that.

In all my appends I always have some criteria.

HTH

Danny