Hi everybody, I am having problem with this query I am using Access database and asp.net c# 2.0 to reterieve things using this query select count(*) as itemTotal from schoolitemmap where (schoolid =1 and OrderDate = 8/3/2009) and itemId = 1 this query does not return nything. (this date used in query is in m/d/y format as a string) and m using date() function as default value for OrderDate field in database which is also in format (m/d/y) Plase help ....... Thanks