type conversion failure during update

G

Guest

i am running an update query to identify the order that gone through so that
i can reduce the stock level accordingly but i keep getting the following
error while running the quey:

"Microsoft Office Access didnt Update 2 fields due to type conversion error"

how do i correct this ?

Thnx in adv
 
K

Ken Snell [MVP]

Sounds as if your query is trying to write a text string into a numeric or
date field, or some other similar issue.

Can't say more than that as I don't know what the query is, what the table
structure(s) are, etc.
 

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

type conversion error during update query 1
Set (9) fields to Null due to type conversion failure !!!! 2
Validation error 5
Type Conversion Failure 3
Add dashes to field.... 1
Importing Into Access - Type Conversion Failure Message 6
Update Query Problems 1
TYPE CONVERSION FAILURE - text to text field 3

Top