Re: [MS_AccessPros] Calculation on formula.

 

Hi Patty,

Since "=, >=, <=" are the possible expressions, I would change your table structure to have two numeric fields and then use a simple "BETWEEN [X Field] and [Y Field]". This would scale more easily to other systems and perform much better than using an expression that needs to be evaluated.

Regards,

Duane Hookom

Switzerland

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Patricia Mapes patty.mapes@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, April 4, 2017 5:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Calculation on formula.

 

The formulas are all text fields but a combination of =, >=, <= and a number character. The values to evaluate are all numbers.

Is there a way to use Val to capture the number value in the text field and then capture the operator portion another way? 

On top of everything we are in the midst of moving and I'm trying to figure this out by phone as work computers are very locked down and I'm moving and temporarily separated from personal machines. 

Thank you for your consideration.

Patty

Sent from my mobile device

On Apr 4, 2017, at 2:01 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Please provide more examples of formulas. 

Duane

Get Outlook for iOS

_____________________________
From: Patricia Mapes patty.mapes@gmail.com [MS_Access_Professionals] <ms_access_professionals@yahoogroups.com>
Sent: Tuesday, April 4, 2017 03:18
Subject: [MS_AccessPros] Calculation on formula.
To: <ms_access_professionals@yahoogroups.com>



Table has a reported value field which is number, and formula field which is text ( > 80) as an example. I need to determine if reported vale satisfies formula and I'm stumped! Appreciate any assistance. Thank you.

Sent from my mobile device

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


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

---

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

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___