datetime and date combine

Hi friends , I have a question during my developing , I have two columns in a table , the data type of the first( column A) is DATE and another ( column B ) is DATETIME HOUR TO MINUTE , the column A means the date that the data inserted , the column B means the time that the data inserted , now , I want to develop a program that user can entry a start date(in the form file it is defined as DATE type )and time (it is defined as DATETIME HOUR TO MINUTE type ) and then entry a finish date and time ,the program will search out the records inserted between the user defined duration , but when I write the program I can not convert the date and datetime type , and can not compose the query statement . can you give me any advice . Thanks in advance JianJun (jjdai@pek-co.cn.dhl.com) -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own