Row Numbering...

Good Day everyone...

I created a simple report for getting the top selling items of a store. I am getting the report well but my team mate requested to include a number at the first column that will hold the ranking of the item. Is there a function for including a rowrank or someway that i can add a column to my query that will provide the rowrank. Please show me how... c",)

thanks in advance guys...

Hi,

Try adding a column wuth this code inside:

=RowNumber(Nothing)
|||

it works. i also thougth of that Rownumber function before, I just dont know what parameter to pass...

Maraming salamat po...

(Thank you very much in Philippines)

|||

DavePH wrote:

it works. i also thougth of that Rownumber function before, I just dont know what parameter to pass...

Maraming salamat po...

(Thank you very much in Philippines)

sql