Prev: passthrough query question
Next: Using a Yes/No field to trigger a calculation in another field - J
From: John W. Vinson on 24 Mar 2010 11:57
On Wed, 24 Mar 2010 03:14:01 -0700, RLyon <RLyon(a)discussions.microsoft.com>
wrote:

>Thanks so much for the response.
>
>Yes it actually turns out to be quite simple if I create the first query
>then go to the SQL window, because it already has the SELECT statement there.
> I added a UNION ALL, then copied and pasted it again, changed the 1's to
>2's. It was late and I didn't finish, so I'll finish it today.
>
>If I do have to break it up, do I then write a second UNION query to put it
>back together?

I'd be inclined to have a properly normalized target table, and then just run
one (or two or three if need be) Append queries based on your UNION queries to
populate it.
--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2
Prev: passthrough query question
Next: Using a Yes/No field to trigger a calculation in another field - J