Prob in qry please help

[KRISH]

Anybody help me.

My problem is I designed a report based on a query, where
I am Calculating [Rank] depending on [Total Marks]
obtained by the candidates institute wise (candidate may
appear more than 1 institute for interview).

Rank expression in my query is like

RankCount([ID],"Qry1","[Inst]='" & [Inst] &"' And [Total
Marks]<=" & [Total Marks])

My report is accepting criteria from form fields.

Now I want to get details of candidate taking [Rank] as
criteria from form fields say [txtFrom] and [txtTo].

The is above is working fine if I give [Inst] as criteria
from my form but if I use Like '*' to display all instt
details, then I am getting so error messages. some times I
am getting like,

"Property not found"

some times like,

"Cannot open any more tables"

sometimes like,

"This expression is typed incorrectly, or it is too
complex to be evaluated. For example, a numeric expresion
may contain too many complicated elements. Try simplifying
the expression by assigning parts of the expression to
variables".

Kindly help me in solving the above problem. Any more
suggestions to get the rank easily is highly appreciable.

Thanks a lot for any help.

KRISH

 

[GVaught]

I'm not sure this is what you want. You can create a criteria such as: Like
[Enter Inst] & *
What this does is prompt for Inst or if entered is pressed all Inst are
returned.