I've got a sql table that is linked into access2007 (latest service
packs, etc)
tblHoliday
holidayId pk
branch text
holidayDate date/time

there is a record where branch is null and holidayDate is
#12/27/2010#

this query works
SELECT branch, holidayDate FROM tblHoliday WHERE holidayDate =
#12/27/2010#

this one doesn't
SELECT branch FROM tblHoliday WHERE holidayDate = #12/27/2010#

yet it works for earlier dates in the table

does anyone have an explanation ?

It doesn't work is not very descriptive of what is happening.

Are you saying that you don't get any row back with the second query or do you
get an error or do you get the wrong results or ...?

Does the following work and return a number other than zero?
SELECT Count(*) as RecordsReturned
FROM tblHoliday
WHERE holidayDate = #12/27/2010#

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Roger wrote:

Roger <lesperancer (AT) natpro (DOT) com> wrote in
news:da173c22-c249-4b5d-a492-a293bfcc75d1 (AT) w4g2000vbh (DOT) googlegroups.com
:

What about:

SELECT tblHoliday.branch
FROM tblHoliday
WHERE tblHoliday.holidayDate = #12/27/2010#

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/