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