Doing a Count in Access 2013 Query -- How to?

[WWGD]

Homework Statement

I have a data table and I am doing a query on some of the attributes.[/B]

Homework Equations

The Attempt at a Solution

I think I need to use $\Sigma$ in the menu bar, but that has not worked.

I know how to return all other query values, but not how to do a count.

Thanks.[/B]

 

[Borg]

Are you just trying to add the values of successive cells?
It would look like this: =SUM(A1:A10)

 

[WWGD]

Thanks Borg, sorry, I was about to say I got it. My new question is how to define a new column that uses the values of two other columns.
I tried :

New Column : (Column i)*( Column j )

Do I need an = after the colon?

 

[WWGD]

Answering my on question: to define a new variable 'varname' , (as a field ) as the product of other fields , we set, in any field entry of the query,

varname: [ field_i, ]* [ field_j ]

of course, one may define new "derived" fields using other arithmetic or logical operations, or maybe both.