Hello again Janet... I am so sorry to be bugging you again on this, but I am having trouble with this new query - not doubt it's something I just don't understand.
If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get results from 08/01/2007. And, if I have them both set to 08/02/2007, I don't get no results at all - but I would expect to set the results from 8/2, which do indeed exist. Note that I am using >= and <= in the query. What am I missing here? Feeling kinda dumb today.... :( >Yes, that looks correct. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4