>I have a field called DollarAmt on a report, along with a running total of DollarAmt into a field called Ord_Tot:
>
> DollarAmt Ord_Tot
>
> 659.75 659.75
> 9,566.20 10,225.95
> 3,380.00 13,605.95
> 3,450.00 17,055.95
>13,316.00 30,371.95
>
>
>
>How do I create this running total in a query?
What is the table structure?
Basically you could self join table and get what you want.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.