When I make an an append query with same type names number of fields the
number of records increases more than 10 fold. Any ideas?
Thanks
Please open the Query and use the View menu option to view it in SQL
view. Post the SQL text here.
I'm guessing that you're creating a Cartesian join by including both
the source table and the target table in the query, with no join
line... it's an easy mistake to make! You don't need the target table
(the table into which you're inserting data) in the query grid.
John W. Vinson[MVP]