Yes, that would be great, but out of my control.
Sent from my mobile device
Sent from my mobile device
On Apr 4, 2017, at 7:26 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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_____________________________
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: Patricia Mapes <patty.mapes@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
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.
.
__,_._,___
Tidak ada komentar:
Posting Komentar