Req: How to get all cells with data into one column

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Currently doing this using an append query, but this is waaay too
cumbersome: I am appending each field with text, one-by-one, from the
populated table into field1 of an empty table. Eventually, when I get
through each column, the target table will have all the cells that
contained any text lined up in one column... I'd like a way to look
that append query, so it runs automatically through each field\column.

Thanks

A
 
I am having trouble understanding what you are attempting to do. Could you
take a few minutes to type/paste several records and the desired output?
 
Dear Adam:

I think what you're getting at here can be done by starting with a
UNION query. Consider something like this:

SELECT Column1 FROM YourTable WHERE Column1 IS NOT NULL

Is this the kind of approach you're using to extract all the values in
one of the columns that "contain any text"? Then, as best I can
figure you're doing this for the next column, and another.

Using the query above, and repeating for additional columns:

SELECT Column1 FROM YourTable WHERE Column1 IS NOT NULL
UNION ALL
SELECT Column1 FROM YourTable WHERE Column2 IS NOT NULL
UNION ALL
SELECT Column1 FROM YourTable WHERE Column3 IS NOT NULL

This kind of query cannot be created in "Design View" but can only be
entered in "SQL View."

Is this anything like what you were needing?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top