type conversion error during update query

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 query:

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

how do i correct this ?

Thnx in adv
 
D

David Seeto via AccessMonster.com

It sounds like the update query is trying to update a field to a value that
isn't allowed by the table - you'll need to post the Update Query and the
Table structure for us to be able to give you any more info.
 

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 failure during update 1
Update Query Problems 1
Set (9) fields to Null due to type conversion failure !!!! 2
Add dashes to field.... 1
Validation error 5
type conversion error 22
lookup table issue (type conversion error) 2
Using an update query to update amount in stock automatically 1

Top