Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 04-05-2009, 03:16 PM   #1
ktmchugh
Registered User
 
Join Date: Apr 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
ktmchugh is on a distinguished road
"Type conversion failure" error when running update query

When I try to run an update query, I am getting an error that says MS Access didn't update (x) fields due to a type conversion failure.

I ran the update anyhow, and the error table said that the field that was posing the problem is not the field I am trying to update. So I have no idea what the type conversion failure is, or how to deal with it. Has anyone dealt with this before and/ or have thoughts about how to fix it?

Thanks!

ktmchugh is offline   Reply With Quote
Old 04-05-2009, 05:39 PM   #2
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: "Type conversion failure" error when running update query

is it an update?
are you sure the error table is the correct one?

i thought you get an error table with an insert, not with an update - but i may be wrong?

anyway - these errors are generally numbers and dates not being formatted correctly
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 04-07-2009, 07:38 PM   #3
ktmchugh
Registered User
 
Join Date: Apr 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
ktmchugh is on a distinguished road
Re: "Type conversion failure" error when running update query

Hi,

Yes it's definitely an update query. I've attached a screen shot of the error message and also the query I'm running. I have run this query on other tables with the same formatting and had no errors. I've gone through and made sure the formatting was correct for the table I'm running this query on, and it's the way it should be (same as the other tables where this has worked). I don't know if there is something about the format of the query expression that would be the problem (although this wouldn't really make sense since it's worked for other tables).

Anyhow, I'm at a complete loss! Any advice would be great!

Thanks!
katie
Attached Files
File Type: doc AccessError.doc (57.5 KB, 311 views)
File Type: doc AccessError_query.doc (66.5 KB, 283 views)

ktmchugh is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Type Conversion Failure in Update Query Jemmo Queries 5 10-09-2008 06:21 AM
update query 3.6z Queries 9 03-18-2008 04:22 AM
Running more than one sql update query davidfox Queries 2 08-26-2005 05:40 PM
a form to update a query to update a form! Please help me dowlingb Forms 3 04-08-2003 03:07 PM
frequently running an update query StephenB Macros 7 06-28-2002 03:46 AM




All times are GMT -8. The time now is 11:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World