I do this exact same thing on a site I'm building, well actually its 4 sites for newspapers.
To do it first you need to make sure you have a "date" field in access, except that you can't name it date, name it something else. Then when you add new content you type in the date you want it displayed in mm/dd/yy format.
Then here is your CFQUERY code:
<BLOCKQUOTE><font size="1" face="Verdana, Arial">code/font><HR><pre>
<CFQUERY DATASOURCE = "DSN" name = "name">
SELECT Text Title Dated
WHERE Dated = #CreateODBCDate(Now())#
What this will do is publish whatever content is dated for that day. At 12:01 AM the next day's stuff is automatically up.