I have a query that can have anywhere from 1 to 6 rows of output. I need a way to be able to know what line the each row is. Below is a rough example of the way the query output is now. At the beginning of each output line I need to have a line (row) number. How do I do this in a query? The methods I have been trying have not worked. My guess is a subquery of some kind but that is not any where near one of my strong suits. Thanks all for help.
2205,57377,ABC,23,2205,55645,95774,406,A520,38.60,CWT,29.47,CWT,1137.54 2205,57377,ABC,23,2205,55645,95774,406,G660,38.60,CWT,6.43,CWT,-248.19
