Database Results Formatting

[John H]

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.

 

[Kathleen Anderson [MVP - FP]]

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.

 

[John H]

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/




.

 

[Bender]

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."

 

[John H]

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?

 

[Guest]

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.