K
KRISH
Hi!
I want to calculate rank in a query (Query Name = [Qry1])
like
Rank: CInt(DCount("[Application ID]","AppInst","[Session]
= '" & [Session] & "' And [Inst Code] ='" & [Inst Code]
& "' And [Dept Code]='" & [Dept Code] & "' And [Selected]
='Yes' And [Total Marks]>=" & ([Interview Marks]+[CAM]+IIf
([Sex]="F",5,0))))
In the above AppInst is also a query where [Total Marks] =
[Interview Marks]+[CAM]+IIf([Sex]="F",5,0)
Now I want to design a report which should accept Rank as
criteria from a form (say between [txtRnkFrom] and
[txtRnkTo]) and display the results.
Please help.
your help is greately appreciable.
Thanks
Krish
I want to calculate rank in a query (Query Name = [Qry1])
like
Rank: CInt(DCount("[Application ID]","AppInst","[Session]
= '" & [Session] & "' And [Inst Code] ='" & [Inst Code]
& "' And [Dept Code]='" & [Dept Code] & "' And [Selected]
='Yes' And [Total Marks]>=" & ([Interview Marks]+[CAM]+IIf
([Sex]="F",5,0))))
In the above AppInst is also a query where [Total Marks] =
[Interview Marks]+[CAM]+IIf([Sex]="F",5,0)
Now I want to design a report which should accept Rank as
criteria from a form (say between [txtRnkFrom] and
[txtRnkTo]) and display the results.
Please help.
your help is greately appreciable.
Thanks
Krish