Date/Time field in MS Access

[yamini]

Hi, I have query regarding Dates/Time field in MS Access.In MS Access Database I am using one of the field is Date/Time.I am using "General Date" .(i.e)6/27/01 6:59:00 .I am using SQL Query to get all the Records within two date ranges.The query looks like this SELECT * FROM WHERE BETWEEN And I am getting all the records inclusive of lower bound but exclusive of the upper bound date. What may be the problem.Have I to modify the query ? Regards, yamini.

[Lost User]

between ? and ? how do you declare the range?,it's very important.

[yamini]

I am giving the sql I used, TableName is "LogTable" DateField is "StationTime" SELECT * FROM LogTable WHERE StationTime BETWEEN #6/25/2001# And #6/27/2001# . In the DataBase I am having Records with Dates ranging from 6/25/2001 to 6/27/2001.I am getting Records with date 6/25/2001 .But could not get the Records with date 6/27/2001. Hope I am clear. Thanx for the Response. Regards, yamini

[Lost User]

You can try #6/27/2001 23:59:59#. I think the default value of time is 6/27/2001 0:0:0.

[yamini]

Yes.Thanx for the idea.I included the time along with date.Now it works perfectly.I am getting all the required records with the lower and upper date bound.The problem is solved. Regards, yamini