title: Returning row number on MS Access
body: <p>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...</p>
  
  <p>In oracle the equiavelent in RowNum.</p>