The Little Guy Posted January 4, 2012 Share Posted January 4, 2012 I am running this query on Access 2007: insert into tblArTransDetailTemp (transId) values ((select max(transId)+1 from tblArTransDetail)); And I am getting this error: Query input must contain at least one table or query. I have no Idea what is wrong, the tables, exist, the columns exist. The sub select works by its self, the insert works by its self, why don't they work as one? What could be wrong? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.