UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Help With Iif Statement    
 
   
deckerf
post Feb 23 2012, 08:43 AM
Post #1

UtterAccess Enthusiast
Posts: 70
Hello,

I'm having trouble with the correct bracketing. Here is what I have so far.

=IIf([A]>0 And [M]=0,">100%",IIf([A]=0 And [M]=0,0,([A]/[M])-1)
Go to the top of the page
 
+
Bob G
post Feb 23 2012, 08:49 AM
Post #2

UtterAccess VIP
Posts: 8,106
From: CT
what version of access are you using?

make sure to count the number of ( to make sure you have the same amount of )
Go to the top of the page
 
+
Alan_G
post Feb 23 2012, 08:52 AM
Post #3

Utterly Yorkshire and Forum/Wiki Editor
Posts: 15,882
From: Devon UK
Hi

It looks like you're just a closing bracket missing from the end -

CODE
=IIf([A]>0 And [M]=0,">100%",IIf([A]=0 And [M]=0,0,([A]/[M])-1))
Go to the top of the page
 
+
deckerf
post Feb 23 2012, 11:27 AM
Post #4

UtterAccess Enthusiast
Posts: 70
That worked thank you very much.
Go to the top of the page
 
+
Alan_G
post Feb 23 2012, 11:34 AM
Post #5

Utterly Yorkshire and Forum/Wiki Editor
Posts: 15,882
From: Devon UK
(IMG:style_emoticons/default/yw.gif)
Go to the top of the page
 
+
« Next Oldest · Access Built-in Functions · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 03:38 AM