[AccessD] Create Junction Table From Existing Data *SOLVED*

Hi Mark

> Although it seemed, at first, rather complicated, the union query worked
> great.  My only thought was I wish there was a simpler way to turn a union
> query into a Make-Table query:(  But we can't have everything, can we?

When I need that, I create the union query as a select query. Then I
use that query as source in a new query (append or create) - that way
you can keep the union query as simple as possible.

/gustav

> I would go with the union query as well.