I am trying to query a table for information after a date using the
following query. This is giving me ALL of the data from the table,
before and after.

SELECT dbo_GP_PumpDownDaily.DateTime, dbo_GP_PumpDownDaily.Location,
dbo_GP_PumpDownDaily.Pressure
FROM dbo_GP_PumpDownDaily
WHERE (((dbo_GP_PumpDownDaily.DateTime)>#2/2/2011#));

If I query for information before my date, it works fine. If I query
for information on my date, it includes all data up to and including
that point.

I was finally able to get it to work when I changed the format so it
goes yyyy/mm/dd. Any idea on why this would be?

SELECT Format([dbo_GP_PumpDownDaily]![DateTime],"yyyy/mm/dd") AS
[DateTime], dbo_GP_PumpDownDaily.Location,
dbo_GP_PumpDownDaily.Pressure
FROM dbo_GP_PumpDownDaily
WHERE (((Format([dbo_GP_PumpDownDaily]![DateTime],"yyyy/mm/
dd"))>Format(#12/25/2010#,"yyyy/mm/dd")));

mcolson wrote:
0:00am. If your field has both date & time, they'll all most likely
have a time greater than 0:00am.

So
FldDate > #12/25/2010# And fldDate < #12/26/2010# would
get all records on 12/25. If you had
FldDate = #12/25/2010#
and the field was date & time, you'd end up with no records.