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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Status Table 2
Date Query 1
Date is Null 6
Formula in Access Query to genrate numbers 1
query brings up wrong dates 4
query before date 1
Renewal query 4
Problems with a select query 2

Back
Top