Prob....... Help plz

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top