Publish known bugs

[FedUpOfAccess2003Bugs]

Please can you publish all known bugs for MS products. As a developer this
would help me enormously.

I am using Acc2003 and I have a scenario where:

Claimed = 500
Cap = 465

and Acc2003 SP2 returns Claimed > Cap = False

Is this a known Access bug or not?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ea858112ed7&dg=microsoft.public.access.macros

 

[Ken Snell \(MVP\)]

Most likely that is not a bug. Instead, it sounds as if the 500 value in
Claimed is a number, but the 465 value in Cap is a text string and not a
real number. Numbers are always "less" than text strings when being compared
by ACCESS.

Try this:

Val(Claimed) > Val(Cap)

The Val function returns the numeric value from a text string based on the
first numbers that are in the text string. For example,

Val("567") returns the number 567.

Val("6U45") returns the number 6.

Val("ABC456") returns the number 0.