SELECT tblNews.newsID, tblNews.dateFrom, tblNews.newstitle, tblNews.newsSummary, qryImages.directory, qryImages.filename, B.rank, tblNews.newsDate FROM tblNews LEFT JOIN qryImages ON tblNews.imageID = qryImages.imageID INNER JOIN ContainsTable(tblNews, *, '#form.criteria2#') AS B ON B.[KEY] = tblNews.newsID WHERE tblNews.newsIsActive = 1 AND tblNews.archived = 0 AND tblNews.dateFrom < getdate() AND tblNews.dateTo > getdate() AND ( tblNews.archived = 1 OR dateTo < getdate() ) ORDER BY tblNews.newsDate DESC SELECT * FROM News ORDER BY rank DESC

Latest News

Search results for '#form.criteria#'

Sorry, there are currently no archive news items to display.

« Previous« Previous

Next »Next »

Showing #url.sRow# to #variables.visMax# (of #News.recordcount#)

#newsTitle# - #dateformat(newsDate, "dd/mm/yyyy")#
#newsSummary# Full story »