Bosna i Hercegovina



#1 01.06.2012-11:19
pmiroslav Offline
Clan
Registrovan/a od: 02.02.2009-10:32
Komentari: 1,371


Subject: IIF isNull problem
Imam tablicu sa numeričkim poljem 'Kolicina', a kako su tu neka polja prazna htio bih u Query-u napraviti da mi u prazno polje upiše nulu. Probao sam ovako:

Komada:IIF(IsNull([Kolicina];0;[Kolicina]))

Ali dobivam poruku 'The expression you entered has a function containing the wrong number of arguments'

U ćemu je problem?
Pozdrav
↑  ↓

#2 01.06.2012-11:43
zxz Offline
Administrator
Registrovan/a od: 03.02.2009-16:22
Komentari: 9,793


Subject: Re: IIF isNull problem
IIF(format$([Kolicina])="";0;[Kolicina])
Pozdrav
↑  ↓

#3 01.06.2012-11:45
pmiroslav Offline
Clan
Registrovan/a od: 02.02.2009-10:32
Komentari: 1,371


Subject: Re: IIF isNull problem
Hvala još jednom.
Pozdrav
↑  ↓

Stranice (1): 1


All times are GMT +01:00. Current time: 13.11.2018-05:37.