ssql = "select '<a
href=""file/filetrack.aspx?fname='||chg_filename||'&'||'fdept='||filemaster.department_code||'&'||'fsection='||filemaster.section_code||'&'||'fyear='||filemaster.file_year||'&'||'fserial='||filemaster.file_serial_no||'"">'||chg_filename||'</a>'
as ""File Name"",file_subject as ""Subject"",office_name as ""Office
Name"", diary_no as ""Diary No"", despatch_date_time as ""Dispatch
Date"" from filetrans,filemaster,offices where
filemaster.department_code = file_department And
filemaster.section_code = file_section And file_serial_no =
file_serial and filemaster.file_year=filetrans.file_year and
offices.office_code=filetrans.office_code and next_office_code = '" &
office98 & "' and next_office_receipt_status = '" & "0" & "' and
file_letter ...
Go to the complete details ...