Ok, I got the query to work the way I wanted it to now... finally... :) Anway, it goes like this: SQL=("SELECT * FROM t_datetable WHERE dDATE<=(DateAdd('H',13,Now())) ORDER BY dDATE DESC") So basically I have the info in my databse set with dates and times, and this query will pull out only the stuff from todays date and previous dates. Thanks for all the help! Christian Anderson Email: chris at photokyo.com Cell/Keitai: digger at ezj.ido.ne.jp URL: http://www.photokyo.com