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
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
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
