Web Development

Ask something
Question Locked

Append Query - "Type Convertion Failure" error???

0 helpful
2 replies

by jxe07

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Have a simple form that is tide to a append query, neew to append a "master" table, query runs, show # records to be appended and then:
MS error: can't append due to:
A type convertion failure" There must be more to this diagostic...

2 replies

by churdoo

One or more of the fields of your form does not match the data type of the corresponding field in the master table that you're appending to. In other words, one of your form fields may be text, trying to append into a numeric field in the master table for example, or text to a date field, etc.

Check all of the field types in your form and compare them to the corresponding fields in the master table.

This discussion is closed to new replies.