Serial Number field in a Query

  • Thread starter Thread starter hhammash
  • Start date Start date
H

hhammash

Guest
Hi all,

I have a table called Subcategories, with one field called Subcategory. The field is a text field.

I would like to create a query which adds another column with serial number that starts with (1) and ends with the last record.

If the query returned 10 records the serial number should be 1-10.

Best regards
 

Users who are viewing this thread

Back
Top Bottom