hello
I have a problem in using date
Database = Access
Visual basic 6
I am connecting Access database in visual basic. I have one field named
saledate : date/time (data format)
I am using query to filer records
query
sql = "select billno,saledate,items,qnt,grandtotal from sales where saledate >= " & Trim(ddate) & "" and saledate<=" & (ldate) & ""
whereas ddate and ldate are input items to filter records the query in now working please guide what is error in above query
Thanks
senthil kumar.A
