John,
>here's the situation:
>
>I do have a select statement:
>
>SELECT t.*, (t.number*t.price) * iif(t.transs = ""CS"" OR t.transs = ""DV"" OR t.transs = ""L "" OR t.transs = ""R "" OR t.transs = ""RC"" OR t.transs = ""RD"" OR t.transs = ""V "" OR t.transs = ""ST"" OR t.transs = ""OP"" , 1, -1) as bruto from trans t
>
>It gives me the following result for bruto:
>
>912414,12124
>12421
>111, 12425235
>etc.
>Any other suggestions ?
How about:
SELECT *, ROUND(number*price * iif(INLIST(transs,"CS","DV","L ","R ","RC","RD","V ","ST","OP" , 1, -1)),2) as bruto
FROM trans
Walter,