M
Matthew
Hello, I have recently created a web site that sends results of my poll to a database. I have set the value of each possible selection to "1". so when a user clicks a radio button and submits it puts the value of "1" in that items row and places a value of zero in each of the other item rows. What I get in my database is a long set of rows where of all the items in each row only one of them actually has a value. What I would like to do is create a data access page with a chart with total votes and number of votes for each item. So I need to know if there is a way access can add all the values in each items colum so I dont have to go through and add them all up myself. Thanks for any help or suggestions, Matthew.