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

[Guest]

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

Thanks in advance.

Kennykee

 

[Duane Hookom]

Might require a union query.

 

[Guest]

Thanks Duane,
I will try it out first.

Kennykee

Might require a union query.

 

[Guest]

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

Thanks in advance.

Kennykee

 

[Rick Brandt]

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

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.

 

[Guest]

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

 

[Duane Hookom]

Maybe don't use lookup fields? Read
http://www.mvps.org/access/lookupfields.htm

You have never described your situation. Maybe you should try that before
you go to far.

 

[Guest]

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