|
| 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
March 6th, 2009, 10:01 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Expression
Hi
We have and expression: =Sum(IIf([Level]=3,[Awarded],0)). I need to change this so that it works if [Level] is 1 or 3 but not sure how this would be done. Would appreciate a little help Many thanks A 
|
|
#2
March 6th, 2009, 10:50 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Expression
=Sum(IIf([Level]=1 Or [Level]=3,[Awarded],0))
"Alex Hammerstein" wrote: Hi We have and expression: =Sum(IIf([Level]=3,[Awarded],0)). I need to change this so that it works if [Level] is 1 or 3 but not sure how this would be done. Would appreciate a little help Many thanks A
|
|
#3
March 6th, 2009, 01:33 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Expression
Thanks for that - I now understand
A On 06/03/2009 10:50, in article , "RonaldoOneNil" wrote: =Sum(IIf([Level]=1 Or [Level]=3,[Awarded],0))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
