help in MS Access query

[Rema]

hi everyone
I am making a MS Access program for inventory..
I need help in making a query for
sum the incoming materials
and outgoing materials !!
should i use (iif) statement ??
so if the transaction type is (in) , it return the amount field , and if the transaction type field is (out) it return (amount * -1 ) ?
then sum the all amounts ??

[Rabbit]

Yes, you can use the iif to flip the sign.

[Rema]

I tried , but it did not work :(
iif([orderDeta!trans]= "in";[det!qy];[det!qy]* -1);
Whats the wrong ?

[Rabbit]

Is orderDeta and det the table names? The delimiter for function arguments are commas, not semicolons.

iif(orderDeta.trans='in',det.qy,det.qy* -1)

[Rema]

yes , they are.
it keeps giving me syntax error :(

[Rabbit]

That usually means one of your fields or table names are spelled incorrectly. Please post the full SQL code

[Rema]

never mind :)
thx ..I fixed it