How to get Row Number in MS Access 2000?

Wilson Hew

New member
Local time
Today, 16:47
Joined
Jan 21, 2003
Messages
7
Hi,

Anyone knows how to get the row number in Microsoft Access 2000?

In ORACLE, we can do like this:

SELECT ROWNUM, Field1, Field2, Field3 FROM Table1;

How do I write SQL statement in MS Access 2000? Thanks.

Wilson
 

Users who are viewing this thread

Back
Top Bottom