IIF(...,..., 0000.00)
>I have this sql in view and it didn't return what I want. i have a table which aamong other field contains tip_dok (field numeric) and iznos (field numeric). i wand to separate the iznos column in wiew so if tip_dok field is 1 populate one column iznos_in, if tip_dok=2 populate the iznos_out column. So i do this...>SELECT Spec_cek.sifra_spec, Spec_cek.data_spec, Spec_cek.docid,; > Spec_cek.tip_dok, Spec_cek.iznos, Spec_cek.specid,; > iif([spec_view_1.tip_dok]=1,spec_view_1.iznos,0) as iznos_in; > iif([spec_view_1.tip_dok]=2,spec_view_1.iznos,0) as innos_out; > FROM blagajna!spec_cek; > WHERE Spec_cek.sifra_spec >= ?pcSifraOd; > AND Spec_cek.sifra_spec <= ?pcSifraDo; > ORDER BY Spec_cek.sifra_spec >>