What function do i use to give a field a ranking based on it’s current sorted position in a query. I do not want to use a running sum on a report – it needs to be in the underlying query as I am going to have to join several together.
Access 2000, Access 2003, Access 2007 forms, Access 2007 functions, Access Database, Access Forms Database, Access reports, BLOB, CLOB, Clustering, CSV, Data structures, Database administration, Database Backup, Database connectivity, Database design, Database issues, Database management, Database migration, Database mirroring, Database servers, DB2 administration, DB2 Universal Database, DBA, DELETE statement, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, Indexes, INSERT statement, IT careers, JDBC, JOIN statement, Microsoft Access, Microsoft Access subforms, Microsoft Access tables, MySQL, MySQL Database, MySQL query, ODBC, Primary keys, QMF, Query optimization, SQL queries, Sybase, tables, Timestamp, Triggers >>VIEW ALL TAGS
