Jump to content

Access 2007

Recommended Posts

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?

Link to comment
Share on other sites

  • 1 month later...

Very late response, but only just spotted this thread. You fix the issue? I suspect Access' rubbish error handling was a red herring, and that the problem is you aren't able to use a sub-query on the same table when inserting into it.

Link to comment
Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.