Hi all,

I have a MS Access database table of 65 columns, the
first of which is the user's name and the rest are
populated with simple check boxes.

Does anybody know how to reformat a database or database
results table so that the header cells are the left
column as opposed to the top row? I have tried to do this
manually, but the table is repeated for each record,
which is not what I want..

TIA

John.

Rather than outputting the results into a table, output it to a List, where
you get a list with each field label and its value. Then create a table with
2 columns and 65 rows and drag and drop each label and value into a table
cell.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


John H <(E-Mail Removed)> wrote:
> Hi all,
>
> I have a MS Access database table of 65 columns, the
> first of which is the user's name and the rest are
> populated with simple check boxes.
>
> Does anybody know how to reformat a database or database
> results table so that the header cells are the left
> column as opposed to the top row? I have tried to do this
> manually, but the table is repeated for each record,
> which is not what I want..
>
> TIA
>
> John.

Many thanks Kathleen
Easy when you know how! :-)

>-----Original Message-----
>Rather than outputting the results into a table, output
it to a List, where
>you get a list with each field label and its value. Then
create a table with
>2 columns and 65 rows and drag and drop each label and
value into a table
>cell.
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/
>
>
>John H <(E-Mail Removed)> wrote:
>> Hi all,
>>
>> I have a MS Access database table of 65 columns, the
>> first of which is the user's name and the rest are
>> populated with simple check boxes.
>>
>> Does anybody know how to reformat a database or
database
>> results table so that the header cells are the left
>> column as opposed to the top row? I have tried to do
this
>> manually, but the table is repeated for each record,
>> which is not what I want..
>>
>> TIA
>>
>> John.
>
>.
>

On Fri, 5 Mar 2004 05:05:55 -0800, "John H"
<(E-Mail Removed)> wrote:

>Many thanks Kathleen
>Easy when you know how! :-)
++++++++++++++++++++++++++++++++++++++++
John....Hint: Make very certain you've got all the fields you need,
etc., cause if you ever have to have the DRW regenerate the results,
you'll have to start all over again. It's a drag...especially when
you have 65 fields to deal with.

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

If you're still there!

I'm having further problems with this. The table is
repeated for each record entered. Is the any way that I
can have only one table, in which the data is populated
once for each record, with common header labels on the
left?

>-----Original Message-----
>Rather than outputting the results into a table, output
it to a List, where
>you get a list with each field label and its value. Then
create a table with
>2 columns and 65 rows and drag and drop each label and
value into a table
>cell.
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/
>
>
>John H <(E-Mail Removed)> wrote:
>> Hi all,
>>
>> I have a MS Access database table of 65 columns, the
>> first of which is the user's name and the rest are
>> populated with simple check boxes.
>>
>> Does anybody know how to reformat a database or
database
>> results table so that the header cells are the left
>> column as opposed to the top row? I have tried to do
this
>> manually, but the table is repeated for each record,
>> which is not what I want..
>>
>> TIA
>>
>> John.
>
>.
>

Hello

Are making something like a list of things and everytime it is checked in the form you want a running total of what was checked? Because I tried to make something like that, but it was a failure.