Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
query % change using IIF first time
Thank you Skip that helped clarify my thinking, my head was spinning around when I wrote the above. I finality ended up with. [Code]SELECT IIf(Sum(Abs(PM29='Yes'))<>0 And...- qwertyth
- Post #4
- Forum: Microsoft: Access Forms
-
query % change using IIF first time
Since I just want the %change regardles of Sum(Abs(Y ='Yes'))>Sum(Abs(X ='Yes'))or Sum(Abs(Y ='Yes'))<Sum(Abs(X ='Yes')) the above needs to be SELECT IIF( Sum(Abs(Y ='Yes'))<>0 and Sum(Abs(X = 'Yes'))<>0 AND Sum(Abs(Y ='Yes'))/Sum(Abs(X ='Yes'))<>1 ,IIF(Sum(Abs(Y='Yes'))>Sum(Abs(X='Yes'))...- qwertyth
- Post #2
- Forum: Microsoft: Access Forms
-
query % change using IIF first time
Hello, I have a table with two fields(text) X, Y, both have 20 entries of yes, no. I am trying to find the percent change in them and am running into trouble if Sum(X='yes')=0 or Sum(Y='yes')=0 or Sum(X='yes')/Sum(Y='yes')=1. I need IF Sum(X)=0 and Sum(Y)=0 then %change=0 IF Sum(X)<>0 and...- qwertyth
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Total=COUNT - COUNT
P.S The Thank dhookom link was not working- qwertyth
- Post #7
- Forum: Microsoft: Access Forms
-
Total=COUNT - COUNT
Thank you both for your reply. They are text fields not yes/no fields, I should have made that clear. The table is not normalized it came from a survey that some else wrote and then handed off to me. I have not used the IFF before, I will read up on it, also Sum(abs(PM11="yes")) is new, new...- qwertyth
- Post #6
- Forum: Microsoft: Access Forms
-
Total=COUNT - COUNT
Hello, first time here,I hope I am posting to the correct forum. I have a table with say 10 columns C1,..,C2 with 20 entry's of yes or no each. I am trying to subtract the COUNT(C2)-COUNT(C1) I am trying SELECT PM11, PM21, COUNT(PM21) - Count(PM11) AS Total FROM tblFlash4 WHERE PM11='Yes'...- qwertyth
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
