Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Row number in MS Access

Comment:

I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In oracle the equiavelent in RowNum.

Outlook folders

Excel XP

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I was wondering what the max number of records that you can enter in Ms Access 2000? ...

Summary: Hello : I am having eternal difficulty trying to manipulate the printer object in MS access 2000. I have scoured msdn libraries, but it provides me with little help. I am trying implement code to f...

Summary: I'm trying to do a minus / except query in MS Access 97 using SQL commands. Here's the SQL code: (SELECT DISTINCT * FROM table1) MINUS (SELECT DISTINCT table1.* FROM table1, table2 WHERE table1.col1 =...