[MS_AccessPros] Eval calculation issue

 

I have a calculation in a query something like this: IIF(Eval("Value" "formula"), "G", "").

In this case the formulas are all over the place and it works well in almost all cases (between, <=, >=, between, =).

Out of about 500 calculations the only ones not calculating are when the values are less .5. Eval( ".31" "<1") produces nothing.

The value is a double; of run it with auto and 2 decimal places.

(".6" "<1") calculates G as it should. I thought it was a rounding issue but I have been through it thoroughly and there is no rounding.

Does any know what this is??

Thank you,

Patty

__._,_.___

---

Posted by: Patricia Mapes <patty.mapes@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___