Sequential Count of rows in a Column

[Former Member]

Hi,

In a query, I have a table defined with the relevant detail required by the business. I need to insert a count into the first column so it identifies a unique number. e.g. row 1 = 1, row 2 = 2 etc.

How can this be done?

[Former Member]

Try adding a formula

[Former Member]

Further to this question, to clarify diagramatically what I'm trying to achieve is as follows:

Row Counter | Header 2 | Header 3 | Header 4

1 data data data

2 data data data

3 data data data

4 data data data

:

:

I need to add the first column into my report but I don't know how to acheive this.

Can anyone assist?