|
 |
access thread: Update problem
Message #1 by "Adeyemi Ajao" <adeyemiajao@h...> on Wed, 26 Dec 2001 09:45:25 +0000
|
|
Hi guys,
Can sombody help treat this problem.
I created an Update query. My computation is based on fields from two
tables. I received this error message each time i run the query.
Microsoft Access can't update all the records in the update query.
Microsoft Access didn't update 2 field(s) due to a type conversion failure,
0 record(s) due to lock violations, and 0 records due to validation rule
violations ...
Thanks guys.
Adeyemi
_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Message #2 by "Tim Nemec" <tim@n...> on Wed, 26 Dec 2001 13:05:32
|
|
Adeyemi:
You didn't give the details of the UPDATE query but is
it possible that your query is failing because some of
the field values are NULL?
Tim
Message #3 by Lonnie Johnson <prodevmg@y...> on Wed, 26 Dec 2001 06:34:09 -0800 (PST)
|
|
--0-903492077-1009377249=:82384
Content-Type: text/plain; charset=us-ascii
...or it could be that you are trying to put text in a numeric or date field (Field Type Mismatch...)
Tim Nemec <tim@n...> wrote: ---
Need a present for your favorite programmer?
E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp
---
Adeyemi:
You didn't give the details of the UPDATE query but is
it possible that your query is failing because some of
the field values are NULL?
Tim
Lonnie Johnson ljprodev@y...
ProDev, Builders of MS Access Databases
Let ProDev build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
Get paid cash every time you receive email!
Sign up FREE at: http://www.MintMail.com/?m=975303
---------------------------------
Do You Yahoo!?
Send your FREE holiday greetings online at Yahoo! Greetings.
Message #4 by "Adeyemi Ajao" <adeyemiajao@h...> on Sun, 30 Dec 2001 01:29:54 +0000
|
|
Hello Dears,
I need an assistant in updating records of a table.
I want to replace the content of a field within a table depending on the
value of another field within thae same table.
I use the statement in a query:
iff([installment]>0,[Loan]*0.5,0)
This was given the error undefined function 'iff'
Please assist.
-Adeyemi
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
Message #5 by "John Ruff" <papparuff@c...> on Sat, 29 Dec 2001 20:10:31 -0800
|
|
Adeyema,
Change your iff statement to IIf([installment]>0,[Loan]*.5,0)
You entered iff, not iif. Also, since this is numberic, you will get an
error if there is no value in the field. In other words, set the
default value to 0.
John Ruff - The Etrnal Optimist :-)
-----Original Message-----
From: Adeyemi Ajao [mailto:adeyemiajao@h...]
Sent: Saturday, December 29, 2001 5:30 PM
To: Access
Subject: [access] Update Problem
Hello Dears,
I need an assistant in updating records of a table.
I want to replace the content of a field within a table depending on the
value of another field within thae same table.
I use the statement in a query:
iff([installment]>0,[Loan]*0.5,0)
This was given the error undefined function 'iff'
Please assist.
-Adeyemi
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
|
|
|
View Cart
