Append query

[Michael Stengel via AccessMonster.com]

trying to append data from one data base (all one table) to a database with
lookups that were created in the table. Trouble is appending text fields to
number fields do to the lookups. How do I write the criteria in the append
query to allow this.
example, Old database, table1, field name "call taker" (text), append to
table2, field name "call taker" (number) do to lookup from seperate table3.

 

[John Vinson]

trying to append data from one data base (all one table) to a database with
lookups that were created in the table. Trouble is appending text fields to
number fields do to the lookups. How do I write the criteria in the append
query to allow this.
example, Old database, table1, field name "call taker" (text), append to
table2, field name "call taker" (number) do to lookup from seperate table3.

What you'll need to do is to base the Append query on a query joining
the wide-flat table to the lookup tables, joining *by the text field*.

That is, join your old (*table*, not database, please!) to the Call
Taker lookup table, joining the text field to the text field. Select
the numeric ID from the lookup table to append to the target table.

Do note that "Lookup Fields" are generally frowned upon: they are
NEVER necessary and frequently cause problems such as the one you're
having! See http://www.mvps.org/access/lookupfields.htm for a
critique. You'll still want to do the append query as I suggest, but
you may want to just use combo boxes on Forms rather than lookup
fields in the table datasheet.

John W. Vinson[MVP]