Is your original query actually missing the quotes? Because this: WHERE expenseDate > #1/1/2006#
means WHERE expenseDate > 0.000498 mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 3 March 2010 11:05, GLM <[email protected]> wrote: > > I don't use access too often and there appears to be major differences > between 2003 and 2007. I've just wasted the last 2 hours trying to get a > simple query to work. > > > > I'm trying to make a basic query for example: > > > > WHERE expenseDate > #1/1/2006# and < #1/1/2007#. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
