need some help with this interrecord stuff

[Anonymous]

I have a table with logging looking like below ...

The Upgrade lines having an empty before should be taken as 'Upgrade', and the first Active following the upgrade should be taken as 'Active' and these two should be combines like the result below:

I'm not really familiar with all the interrecord kind of things, but I assume I need to use something like that to get the result above.

Anyone has suggestions how to start?

thx in advance,

Anita

[Anonymous · Accepted solution]

Solved it myself ...

I first select all relevant info from the table ... for both U and A ... so the rows which are garbage are thrown away.

After this I order the table descending and with the previous function I'm looking if the previous field is an 'A' field ... if so the data is combined.

The next step is to remove the 'A' from the list, so only the combined rows are left over.

Took me a while ... but happy with the result ...