MS-Assess: Query help

If you've a question about tech issues, post a question in the QUESTION area and if someone can, they will help you with it.

Append Queries don't return result sets
So you can't select from them.

You do the append and then select from the table you appended to.

There's a trick to asking tech questions. Essentially it's not looking for how to do the wrong answer.

PS Which bit of Start a Discussion / Start a Question didn't you understand?

Oh and if you do ask one don't do it with a link to another site.

Try reposting this using the 'Ask a Question' button. The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution.

On the 'Questions' forum you'll find TR members who specifically seek out problems in need of a solution. You'll find more of those members in 'Questions' than here in 'Discussions'.

Additional benefits to the membership include:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The revised TR makes it quite difficult to find both "Discussions" and "Questions" that have not had a fairly recent post, owing to some functions co-mingling them in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for.