Thanks for the response but all that is just giving me the row count minus 1 not the sequence of the distinct variable1. If variable 1 value is 123456 and...

Sorry I tried to edit the original post and could save the edit.

I have a query that I need to add a sequence to for a report and I am...