SELECT tblConferences.conferenceID, tblConferences.conferenceTitle, tblConferences.dateFrom, tblConferences.dateTo, tblConferences.summary, tblConferences.body, tblConferences.location, tblConferences.download1Name, tblConferences.downloadPDF1, tblConferences.downloadSize1, tblConferences.download2Name, tblConferences.downloadPDF2, tblConferences.downloadSize2, tblConferences.contactName, tblConferences.company, tblConferences.email, qryImages.directory, qryImages.filename FROM tblConferences LEFT JOIN qryImages ON tblConferences.imageID = qryImages.imageID WHERE tblConferences.conferenceID = SELECT tblConferencePDFs.pdfTitle, tblConferencePDFs.pdfName, tblConferencePDFs.pdfSize FROM tblConferencePDFs WHERE tblConferencePDFs.conferenceID =

#conferenceTitle#

Date: from #dateFrom# to #dateTo#
Location: #location#
Details:
#body#
Contact Details:
Name:#contactName#
Company:#company#
Email:#email#
Download Details: #ConferencePDFs.pdfTitle[ConferencePDFs.currentrow]# - #lsnumberformat(ConferencePDFs.pdfSize[ConferencePDFs.currentrow]/1024, ".00")#KB

Back to list