How will i create a sql statement about date in ms access?

I've tried to use the where service_date %26lt; 03/13/2007.. but it does not give me the logical result that i need...please help me...can you help me to get all the data that the date will not be greater than October 28, 2006..thanks...i only need the where part...thanks...|||October 28, 2006





You will probably have to use the hash mark '#'


i.e. %26lt;= #28/10/2006# or the American version %26lt;=#10/28/2006#





HTH|||I'll try to help if this isn't it, but did you try a few different date formats?





where service_date %26lt;= '10/28/2006'





where service_date %26lt;= '28/10/2006'





where service_date %26lt;= '2006-10-28'





or even





where service_date %26lt;= '10/28/2006 00:00:00'