Populate a table

[Dominick D.]

Hello, is there a way to populate a table, where the records are in column by
column, as opposed to the standard row by row? For Example:

FIELD 1 FIELD2 FIELD3 FIELD4

DATA DATA DATA DATA

this is row by row. The usual way. What I want is to populate a table column
by column, like this:

FIELD1 DATA

FIELD 2 DATA

FIELD3 DATA

Is there a way to do this?

 

[Dale Fye]

Dom,

Can you give us a little better explaination of what your actual data looks
like? If you know better than to do this, which you clearly do by your
comment, then why do you feel you need to do it anyway?

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Dominick D.]

Hi, and thanks for your reply. In a nutshell, when you run a query, the
output is rows of data, like this:

field1 field2 field3
data data data

This constitutes a row. What I need is the output of a query to look like
this:

field1 data
field2 data
field3 data

The "row" of data is to be a "colum" of data, as shown above.

 

[Evi]

Click on your closed table, go to Insert, Autoform, Columnar Does that give
the results you want?

Evi

 

[Dale Fye]

If Evi's suggestion doesn't get you what you want, the I would suggest what
I would call a normalization query.

Generally, when you get a spreadsheet of data it is dorked up (data as
column headers), for my example we will assume that the spreadsheet rows are
Items, and the columns are months of the year (Jan, Feb, Mar, ...), and the
cells of the spreadsheet are the numbers of items sold. To normalize this
table you want it to look like:

MonthSold Item QtySold

To get to this, I would write a query that looks like:

SELECT "Jan" as MonthSold, Item, NZ([Jan],0) as QtySold
FROM yourTable
UNION ALL
SELECT "Feb" as MonthSold, Item, NZ([Feb],0) as QtySold
FROM yourTable
UNION ALL
SELECT "Mar" as MonthSold, Item, NZ([Mar],0) as QtySold
FROM yourTable
....

You get the idea.

HTH
Dale