rowno in query

[A S MANN]

Is their a way to give row no in a query. it works in forms as ROWNO() function and = 1 in report but it do not work in query.

[isladogs]

It's much harder in a query. What you need to do is a rank order query.
I find it easiest to do this using a Serialize function.

See this link http://www.mendipdatasystems.co.uk/r...ies/4594424063