Prob. ......... plz help

K

KRISH

I am having a query [AppInst], where i am calculating
[Total Marks]= (([Interview Marks]+[CAM]+IIf([Sex]
="F",5,0))

Now I designed a report based on a query, in this query i
am calculating as follows

Rank: DCount("[Application ID]","AppInst","[Session]= '" &
[Session] & "' And [Inst Code] ='" & [Inst Code] & "' And
[Dept Code]='" & [Dept Code] & "' And [Selected] ='Yes'
And [Total Marks]>=" & CCur(([Interview Marks]+[CAM]+IIf
([Sex]="F",5,0))))

The above is working fine if I dont specify any criteria
for [Rank]. But I want to give criteria for [Rank] in the
where condition of the same. If I specify any criteria say
1, 2 or 3 .... it is giving an error, saying too complex
to evaluate expression and asking to simplify the
expression. Kindly help me to solve the problem.

Thanks
 

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

Similar Threads

Prob....... Help plz 0
Report Prob.... 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Prob in qry please help 1
Setting up the following expression in a query 2
IIF in a report Footer 3
Need help with Expression 1
Using Max or DMax in DLookUp criteria? 1

Top