I am getting the errorr syntax errorr in INSERT INTO statement when running this through access vb but when I run the same query (got from debug.print cQuery) in access query section it appends the records in table. Can anybody help me out on this problem.
Private Sub CmdRpt_Enter()...