Displaying Columns as Rows

[structure]

I am querying records from a database that contains 96 columns. Since all that data is related, I would like to display the 96 columns as one column with 96 rows. How can I do this?

 

[Rich]

Don't understand are you saying you have 96 fields with one value in each. There would appear to be a structure design problem at first sight. Please give some further details
of your table.

 

[structure]

I am performing a query that returns values for each 15 minute period in given day. So when I query for a given date, I'm returned a row from the data base which displays a value for each of the 96 intervals (int001, int002, int003...etc.) Because they are all part of the same row in the database, that's how they are being returned. What I would like to do is perform a query that would return those values not in a row, but under a single column...hope this helps!

[This message has been edited by structure (edited 08-29-2001).]

 

[shacket]

Rich is correct. The problem is structural. Your database should be designed with three fields in the table:

Date
Increment
Data

Then each increment is listed as a record (as opposed to a field) so you can query and list them correctly. You can use a make table query (though it will be tedious) to produce a correctly formatted table from the one you currently have.

[This message has been edited by shacket (edited 08-29-2001).]

 

[structure]

Yes, that's all true. Unfortunately I'm querying someone else's database and don't have the luxury of being able to adjust the design. I knew this would be pretty difficult to pull off. Thanks for the help anyway though!

 

[shacket]

Depending on how you are running it, you could design the Make Table query (it would be much easier to run from VBA) and simply run that query to format the other person's info correctly into your table, then run your database off of that. If you are using this information on a consistent basis (instead of here and there), it would be too cumbersome.