Ranking in Access 2003

[Guest]

I cannot figure how to rank a calculated field in a query. I want to the
field in the query to rank the total score that the query generates.

 

[Allen Browne]

See:
How to Rank Records Within a Query
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208946

 

[Guest]

Allen:
Thanks for the reply. I have this document and have tried to replicate what
it states, but I cannot get the syntax to work in 2003. This document was
written for Access 2000 and I do not know if changes have been made. Any
thoughts you might have would be helpful.
Chris

 

[Allen Browne]

Access 2003 uses exactly the same query engine (JET 4) as A2000.