G
Guest
Is there a way to generate a running sum in a query? I know that in a report
you can add a field and set it up as a running sum (i.e. first record in a
group = 1, second record = 2, etc..), but can you do so in a query? In
otherwords, I want a query to have a field that has the row number in it. Is
there a way to do this?
you can add a field and set it up as a running sum (i.e. first record in a
group = 1, second record = 2, etc..), but can you do so in a query? In
otherwords, I want a query to have a field that has the row number in it. Is
there a way to do this?