No problem with using DateDiff() as he is using it, since it is not surrounded by #. It has been a bazillion years since I've used Access, but as I recall, that particular error message has something to do with a lack of quotes (e.g. 'foo') on a field that the driver wants them on. Maybe the date field? Can't remember for sure.
On Thu, Sep 11, 2008 at 7:28 PM, Mike Little wrote: > at a rough guess, i suspect that you cannot use an explicit cf function > such as datediff in the query. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
