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

1. Feb 17, 2015

### WWGD

1. The problem statement, all variables and given/known data
I have a data table and I am doing a query on some of the attributes.

2. Relevant equations

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

2. Feb 17, 2015

### Borg

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

3. Feb 17, 2015

### 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?

4. Feb 17, 2015

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