Database Results Formatting

J

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

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

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/




.
Click to expand...
 
B

Bender

Many thanks Kathleen
Easy when you know how! :)
Click to expand...
++++++++++++++++++++++++++++++++++++++++
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."
 
C

Chris

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