Query: why record with earlier date appears in my query

  • Thread starter Thread starter Mingman Xu
  • Start date Start date
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.
 
"Date" is a reserved word and should not be used as a field name. First
thing is to change the field name.
 
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.
 
Back
Top