|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 5th, 2005, 06:30 PM
|
|||
|
|||
Combine Statements
Can someone help me to combine these statements below?
=Sum(IIf([Status]="Win" And [Region]="Mid-Atlantic",1,0)) BTW this is text box89 AND =[Text89]/[Overall Count of All] I can't figure out how to make these work in one. Thanks! 
|
|
#2
August 6th, 2005, 08:04 PM
|
|||
|
|||
|
To foolow you two fields then it should be
=Sum(IIf([Status]="Win" And [Region]="Mid-Atlantic",1,0))/[Overall Count of All] "_" wrote: Can someone help me to combine these statements below? =Sum(IIf([Status]="Win" And [Region]="Mid-Atlantic",1,0)) BTW this is text box89 AND =[Text89]/[Overall Count of All] I can't figure out how to make these work in one. Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I merge these SELECT statements... | Lyndon | Running & Setting Up Queries | 1 | August 10th, 2005 08:13 AM |
| Combine and Decode not working | Gary Cahn | Outlook Express | 3 | January 27th, 2005 09:15 PM |
| How to combine documents | Vijay J. | Formatting Long Documents | 6 | November 16th, 2004 10:04 AM |
| multiple sql statements in OLE DB command | Jerry Nettleton | Running & Setting Up Queries | 2 | June 18th, 2004 04:58 AM |
| IF Statements | Bill | Worksheet Functions | 8 | February 6th, 2004 06:46 PM |
Linear Mode
