>>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.
Thank you, Naomi.
I'll take a look
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.