<ol>, :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: Oliver Lineham : : the easiest way around this is to use DateCompare() : instead of >= : : eg. DateCompare(show.showdate, now(), "d") : : the "d" makes it precise to the day. :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ how exactly do you propose to use the datecompare() function in a query? thanks, .jeff name://jeff.howden game://web.development http://www.evolt.org/ mailto:jeff at members.evolt.org