How do I write a IIf statement with multiple criteria

[Stayingahead]

I am writing a query that separates Cash, Expenses and Revenue in separate columns. Each of these has its own [Object_Code]for each [Amt_Posted]. The object codes I have been useing are:
100 - Cash
600 - Expenses
400 - Revenues (But I also have other Revenue codes - 401, 402, 403, 410, 411, 420, 440, 450)

THe IIF statement I wrote for the Cash and Expenses works well, but I'm having problems writing one for the Revenues that will place all of the reveneues in the same column.

Here is the IIf statement I use for the expenses.
Expenses:IIF([Obect_Code]=600,[Amt_Posted],0)

How do I modify it to include all of the 400 series Revenue objects?

 

[PHV]

Revenue: IIf(([Object_Code]\100)=4,[Amt_Posted],0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Stayingahead]

PH
I tried the modified statement and it doesn't work. I am working with a link table and our Central Office has set the [Object_Code] up as a "text" field and they won't change that.

Any other ideas?

 

[PHV]

Revenue: IIf(Left([Object_Code],1)="4",[Amt_Posted],0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Stayingahead]

Thanks PH

I was making it too hard. After you think about it, this makes sense. Thanks again