please i am looking for some help.....We connect access as front end db to sql 2005 as back end db.id we execute some sql statments to fetsh sql table to access table but it gives me a message error :"Undefined function Getdate"the used sql code is as follows:insert into x_trans select group_code, file_no, stamp_date AS doc_date, doc_type, value_date, doc_value from trans where group_code = 30101 and file_no = 17276 and doc_type >= 5 and doc_type <= 8 and value_date >= '2010-03-01' and value_date <= '2010-05-31'"
vb & access odbc sql ERROR
Posted - 2010-09-19 : 06:06:50
