SQLSTRTING="select * from table name='where field" & amp; Data & amp;"='data' 'and the field name and field name=' "data" and the field name between "data" and "data" the order by the field name asc "this is the statement want to change into SQL SERVER Access statement of how to convert? Seek help from a great god