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#.
Every query except for expenseDate works correctly for example:
expenseSourceID = 7 AND
expenseTypeID = 1
I don't get any error msg using expenseDate.
The problem is that
expenseDate > #1/1/2006# and
expenseDate > #1/1/2007#
result in the same number
and
WHERE expenseDate > #1/1/2006# and < #1/1/2007#.
Results with 0.00
The datatype is date/time and the format is m/d/yyyy and the data is in the
same format. I've tried retyping some of the data in so it shouldn't be a
format issue. If it was I would either get an error msg or the retyped data
would be summed.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:331285
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
