SELECT fileName FROM tblNewsBriefs WHERE newsID = #newsid# SELECT fileName,newsdate,newsid FROM tblNewsBriefs where newsDate >= #createODBCDate(DateAdd("m", -1, now()))# order by newsid desc