summing up the values in a column

[jermadem]

this has to be more simple than it seems, i just can't seem to get it to work, and yes, i'm pretty new at Access.

i have a table that is filled with values from a survey. we'll take 4 columns for example. if somebody checked a box on the survey, a "1" was entered into the appropriate field in the database. so for our 4 columns (ans1, ans2, ans3, ans4) there will either be a 1 or nothing.

all i want to do is have a query that can create one row that has "ans1", "ans2", "ans3", "ans4" as the column headings and a total number of 1's in each column. so if 10 people respond to the survey, and only 4 check the box for ans1, i just want a "4" displayed in the query.

have i over explained this yet?

funnily enough, i know how to add fields from multiple tables together, i just can't seem to figure out how to add together everything in one column...

 

[jermadem]

thank ya

Use a totals query. Create a new query that selects all the columns. Press the sigma button (funny E). Change the Group By's to Sum's for the columns you want to sum.

THANK YOU! It was giving me an error at first, but then i realized i needed to change the fields to numbers instead of text fields. duh.