>The table contains these columns:
>sytemid
>eventtime
>eventcode
>eventamount
>
>I want a report that shows, for each systemid, the sum of the eventamount column for an event until another event occurs, the events are in eventime sequence.
>Event A could have one row, then an event B at a later time, and then another A at yet a later time. I that case I want three totals.
>
>
>
>HELP!
Google on Gaps & Islands to create proper query and then just report of that.
If it's not broken, fix it until it is.
My Blog