creating query

[ashishkukreja]

I have 2 coloumns

Size------------Sale (in bottles)

750------------900
1000-----------450
750------------30
90-------------80
1000----------60
90-----------57

Now I want to create a query containing one more coloumn which is
Sale (in cases).

If size =750 it divided by 12,
If size =1000 it divided by 9 and
If size =90 it divided by 100

and this value save in another coloumn Naming Sale (in cases)

please help me creating a query on this

Thanks
Ashish

 

[Brianwarnock]

use nested IIF statements.

sale_cases: IIf([size]=1000,[sale_bottles]/9,IIf([size]=750,[sale_bottles]/12,IIf([size]=90,[sale_bottles]/100)))

Brian

 

[ashishkukreja]

Thank you sir for your reply

Thanks
Ashish