Thanks all of you for the replies. I have had a brief read of the article you recommended and that has clarified the function of the transaction log. What documentation...

Thanks for your reply.

I did eventually manage to do this in the report writer, once I got around the problem of it ignoring any record that has a null value...

Thanks for the reply. Unfortunately, this did not resolve the 'shifting blank fields up' issue, but it gave me an idea whereby I could achieve that in the reporting system....

Hi

Yes, I think I do understand it, as I have had to tweak it to meet a number of varying conditions. One of the c6 variants is shown below. You...

Thanks for this. It works! Thanks very much.

Tom