Many thanks for all the replies. Have tested all suggestions. Findings as follows...
CJ_London, could not get your sql to work. Tried several minor alterations, but the following error kept presenting. Any ideas?
Plog, read_date is unique and your code works fine.
JHB, crosstab works very...