Query: why record with earlier date appears in my query

M

Mingman Xu

Hi there. When I set DATE >=#2004-8-27# in my query, why record with date
2004-8-26 appears in the query result? I did input that record on 2004-8-27,
but I set the DATE = 2004-8-26. Any help will be appreciated.
 
P

PC Datasheet

"Date" is a reserved word and should not be used as a field name. First
thing is to change the field name.
 
V

Van T. Dinh

Try

[YourTable].[Date] >= #08/27/2004#

The full reference and the square brackets around DATE should identify the
Field rather than (possibly???) the Date() function.
 
Top