By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Appending queries

P: n/a
I have set up queries in access that make tables and then append them
to each other. Unfortunately the resulting table after three seperate
tables are appended does not comprise of all the entries in each table.
Can any one tell me why this is. Thanks alot.

Also, since I am appending three seperate queries, the user is asked
for the word they are looking for three times and I was wondering
whether it would be possible to just set the word to be the same across
all the three queries? Thanks again.

Jun 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 7 Jun 2006 06:23:34 -0700, sj****@gmail.com wrote:

Assuming you are using a Union query, try Union All:
select * from table1
union all
select * from table2
union all
select * from table3

You lost me on your second question.

-Tom.

I have set up queries in access that make tables and then append them
to each other. Unfortunately the resulting table after three seperate
tables are appended does not comprise of all the entries in each table.
Can any one tell me why this is. Thanks alot.

Also, since I am appending three seperate queries, the user is asked
for the word they are looking for three times and I was wondering
whether it would be possible to just set the word to be the same across
all the three queries? Thanks again.


Jun 7 '06 #2

P: n/a
sj****@gmail.com wrote:
I have set up queries in access that make tables and then append them
to each other. Unfortunately the resulting table after three seperate
tables are appended does not comprise of all the entries in each table.
Can any one tell me why this is. Thanks alot.


probably violating table definitions. try stepping through the queries
manually and ensure the warnings are set to on (docmd.setwarnings
true). Read the append query notices and check what they say.

Jun 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.