Parameter problem!

[Domac]

Hi,

I am calculating field value based on values of other field in query , like
field "Ukljuciva" defined below.

Ukljuciva: Switch([PlRok] Is Null;0;[PlRok]<Date();0;[PlRok]>Date();1)

Then I calculate other field named "VzaIzv" defined below.

VzaIzv: IIf([Ukljuciva]=0;[ZaIzvrsiti];[ZaIzvrsiti]-[PlKol])


The problem is that everything works fine untill I put criteria for field
"VzaIzv" then it prompts me for value [Ukljuciva] which is field before in
order of field [VzaIzv].


Thanx!

 

[John Spencer]

You will have to repeat the calculation in the second calculated field

Ukljuciva: Switch([PlRok] Is Null;0;[PlRok]<Date();0;[PlRok]>Date();1)

Then I calculate other field named "VzaIzv" defined below.

VzaIzv: IIf(Switch([PlRok] Is
Null;0;[PlRok]<Date();0;[PlRok]>Date();1)=0;[ZaIzvrsiti];[ZaIzvrsiti]-[PlKol])

Although if I read your logic correctly, you could use
VzaIzv: IIf(Nz(PlRok,Date()-1)<Date();[ZaIzvrsiti];[ZaIzvrsiti]-[PlKol])