Query Append Query!!!!!!!!!!!!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone can tell me how to append a query to another query?

Thanks in advance.

Kennykee
 
Why the union query is a blank page?
How to write the sql statement?

Thanks in advance.

Kennykee
 
kennykee said:
Why the union query is a blank page?
How to write the sql statement?
Click to expand...

Unions cannot be created in the graphical query builder. You have to enter the
SQL directly. You can use the builder to create each "piece" and then cut and
paste the SQL from both into the Union query window.
 
Thanks Rick

But i found another easier way that is append query. The problem is I cant
append a lookup field to another lookup field

How to solve this problem or any alternative method?

Thanks in advance

Kennykee
 
Thanks all.
I know why I cant append query on lookup fields, the lookup fields contain
ID which is not duplicable

The table is for archive purpose

So I will try append programmatically. I will post my question to
programming sections.

Thanks.

Kennykee
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule Auto run Query on append table 0
query field names changing to expr#: 8
linked worksheet connection error 5
Append Lookup!!!!!!!!!! 5
Append Query Issue 0
Access 2010 append query to SQL is very slow 0
Append Query is not working 1
Pull a field from a form to be the criteria of an append query 0

Back
Top