OK I hve is sussed;
SELECT '[' + cstr(log_no) + '] ' + format(logged_dated, 'dd/mm/yyyy') + ' ' + LEFT(description, 40) AS log_detaill, log_no
FROM tblLog
ORDER BY log_no
I am doing this so that the log detail combo box displays the log number, the date and the first 40 characters of the description in one column.
thus..... [23] 30/8/2004 This is some text from the log
Thnx:)