Update currency field

[DMUM via AccessMonster.com]

Hello, can someome please tell me why this update statement is finding 0
fields to replcae whrn I know I have 10 fields?

strSQLUpdate = "UPDATE [" & tblName & "] SET [" & tblName & "].[" & colName &
"]= True"
strSQLUpdate = strSQLUpdate & " WHERE [" & tblName & "].[" & whereField & "]
= " & whereCriteria
DoCmd.RunSQL strSQLUpdate

I am not getting an error, only the message that tells me how many fields
will be updated - in this case I always get 0

--
Message posted via http://www.accessmonster.com

[Larry Linson]

Could it be because "True" is not a valid value for a Currency Field?

Larry Linson
Microsoft Access MVP

"DMUM via AccessMonster.com" <u16673@uwe> wrote in message
news:626b93a20ff3d@uwe...

Hello, can someome please tell me why this update statement is finding 0
fields to replcae whrn I know I have 10 fields?

strSQLUpdate = "UPDATE [" & tblName & "] SET [" & tblName & "].[" &
colName &
"]= True"
strSQLUpdate = strSQLUpdate & " WHERE [" & tblName & "].[" & whereField &
"]
= " & whereCriteria
DoCmd.RunSQL strSQLUpdate

I am not getting an error, only the message that tells me how many fields
will be updated - in this case I always get 0

--
Message posted via http://www.accessmonster.com

[DMUM via AccessMonster.com]

Hi Larry

I actually found the problem, but I don't know what to do to address it...

The code works unless the number in the field is actually a rounded figure. i.
e if the number is 10.00 - it works. if the number is 10.045 rounded to 10.
00 it does not. I know it wants to find the "whole number" but you can't
tell that the number is rounded by formating unless you click on it. Any
suggestions?
Larry Linson wrote:

Could it be because "True" is not a valid value for a Currency Field?

Larry Linson
Microsoft Access MVP

Hello, can someome please tell me why this update statement is finding 0
fields to replcae whrn I know I have 10 fields?

[quoted text clipped - 9 lines]

I am not getting an error, only the message that tells me how many fields
will be updated - in this case I always get 0

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[Bob Quintal]

"DMUM via AccessMonster.com" <u16673@uwe> wrote in
news:626bdfa89b35a@uwe:

Hi Larry

I actually found the problem, but I don't know what to do to
address it...

The code works unless the number in the field is actually a
rounded figure. i. e if the number is 10.00 - it works. if
the number is 10.045 rounded to 10. 00 it does not. I know it
wants to find the "whole number" but you can't tell that the
number is rounded by formating unless you click on it. Any
suggestions?

Compare rounded numbers.
e.g. Where round(CurrencyField,2) = 1.23
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[DMUM via AccessMonster.com]

Thank you Thank you

Just what I needed!

Bob Quintal wrote:

Hi Larry

[quoted text clipped - 7 lines]

number is rounded by formating unless you click on it. Any
suggestions?

Compare rounded numbers.
e.g. Where round(CurrencyField,2) = 1.23

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[Larry Linson]

Glad you got it working. What is the result of updating a Currency Field to
the value of True?

Larry Linson
Microsoft Access MVP

"DMUM via AccessMonster.com" <u16673@uwe> wrote in message
news:626c0f15a1bca@uwe...

Thank you Thank you

Just what I needed!

Bob Quintal wrote:

Hi Larry

[quoted text clipped - 7 lines]

number is rounded by formating unless you click on it. Any
suggestions?

Compare rounded numbers.
e.g. Where round(CurrencyField,2) = 1.23

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[Bob Quintal]

"Larry Linson" <bo*****@localhost.not> wrote in
news:zSjog.4630$uo.628@trnddc07:

Glad you got it working. What is the result of updating a
Currency Field to the value of True?

Larry Linson
Microsoft Access MVP
The account contains $ -1.00, thanks to Access typecasting.

Q

"DMUM via AccessMonster.com" <u16673@uwe> wrote in message
news:626c0f15a1bca@uwe...

Thank you Thank you

Just what I needed!

Bob Quintal wrote:

Hi Larry

[quoted text clipped - 7 lines]
number is rounded by formating unless you click on it. Any
suggestions?

Compare rounded numbers.
e.g. Where round(CurrencyField,2) = 1.23

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For.../databases-ms- acce ss/200606/1

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Larry Linson]

"Bob Quintal" <rq******@sPAmpatico.ca> wrote

The account contains $ -1.00, thanks to Access typecasting.

Do you think that could really have been the point of that update query?

Larry

[Bob Quintal]

"Larry Linson" <bo*****@localhost.not> wrote in
news:RHmog.4658$uo.2299@trnddc07:

"Bob Quintal" <rq******@sPAmpatico.ca> wrote

The account contains $ -1.00, thanks to Access typecasting.

Do you think that could really have been the point of that
update query?

Larry

I doubt it very much, however I'm sure it was disguised in order to
protect information. :-)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Larry Linson]

"Bob Quintal" wrote

The account contains $ -1.00, thanks
to Access typecasting.

Do you think that could really have
been the point of that update query?

I doubt it very much, however I'm sure
it was disguised in order to
protect information. :-)

You are likely correct. However, I must admit that sometimes it strikes me
that anyone who can't go to the trouble of at least creating logical,
rational "disguised information" may not really be seriously in need of a
logical, rational answer. :-)

Larry