query criteria gives wrong information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the Access 2000 version i have set up the following SQL statement:

SELECT [Jane Providers].[Contact Name], [Jane Providers].Address, [Jane
Providers].City, [Jane Providers].[Social Worker], [Jane Providers].[Meeting
Date], [Jane Providers].[Follow up Date], [Jane Providers].PhoneNumber
FROM [Jane Providers]
WHERE ((([Jane Providers].[Meeting Date]) Between (1/2/2006) And
#2/28/2006#));

UNfortunately, the data that it gives me is for some dates from 2005..
Does anyone know what the problem is? thanks in advance
 
Try putting hash marks around the start date (1/2/2006) as well, as in
#1/2/2006#

Or am I missing something?

Sam
In the Access 2000 version i have set up the following SQL statement:

SELECT [Jane Providers].[Contact Name], [Jane Providers].Address, [Jane
Providers].City, [Jane Providers].[Social Worker], [Jane Providers].[Meeting
Date], [Jane Providers].[Follow up Date], [Jane Providers].PhoneNumber
FROM [Jane Providers]
WHERE ((([Jane Providers].[Meeting Date]) Between (1/2/2006) And
#2/28/2006#));

UNfortunately, the data that it gives me is for some dates from 2005..
Does anyone know what the problem is? thanks in advance
Click to expand...
 
Back
Top