Merge data for graph

[Guest]

I have a table which has 4 columbs for the same thing, this is because for
each record there are upto 4 possible outcomes. To generate a graph i would
like to have the data from the 4 columbs to be evaluated as one columb
instead of 4.

The table looks like this

action_taken_1 | action_taken_2 | action_taken_3 | action_taken_4
7 | 2 | 6 |
1
2 | 9 | 4 |
7

I think an update query is what i may need but i am not sure where i am
writing the statement to execute this.

 

[Jeff Boyce]

If you have repeating columns (4... for the same thing), your data is more
like a spreadsheet than a relational database (e.g., MS Access). Have you
looked into using Excel instead? You can do graphs from there, too.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/