I am trying to append to a table as a method of storing information for a report. To do this, I am using currentdb.execute "INSERT INTO....." and I get an error about the first field to be appended being unkown. I copy the query into access, reformat it, run it and everything works. Any ideas...