Access function or expression equivalent of SQL ROW_NUMBER()? | ansaurus

tags:

views:

88

answers:

1

Q:

Access function or expression equivalent of SQL ROW_NUMBER()?

Is there anything I can do in Access that would mimic the behavior of the TSQL ROW_NUMBER() function, when doing an INSERT query?

A:

An oldie but goodie:

How to Rank Records Within a Query
http://support.microsoft.com/kb/208946

Robert Harvey 2010-08-18 21:16:25

related questions

*= in Sybase SQL

sql missing rows when grouped by DAY, MONTH, YEAR

Adapt Replace all strings in all tables to work with text

Can you call a webservice from TSQL code?

How to tell the data types after executing a stored procedure?

C# - SQLClient - Simplest INSERT

SQL Server: Get data for only the past year

Get last item in a table - SQL

Is there a way to make a TSQL variable constant?

Create a database from another database?

SQL Server PIVOT examples?

What are some references, lessons and or best practices for SQL optimization training.

What's a good way to check if two datetimes are on the same calendar day in TSQL?

Trigger without a transaction?

How do I do an Upsert Into Table?

What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?

How do I avoid using cursors in Sybase (T-SQL)?

Best .NET Solution for Frequently Changed Database

T-Sql date format for seconds since last epoch / formatting for sqlite input

HOWTO - Compare a date string to datetime in SQL Server?

Differences Between MySql and MS SQL

Best method for varchar date validation in Sybase (T-SQL)?

interrogating table lock schemes in T-SQL

Testing for inequality in T-SQL

T-Sql Remove Decimal Point From Money Data Type