1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

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

  1. Feb 17, 2015 #1

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    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. jcsd
  3. Feb 17, 2015 #2

    Borg

    User Avatar
    Science Advisor
    Gold Member

    Are you just trying to add the values of successive cells?
    It would look like this: =SUM(A1:A10)
     
  4. Feb 17, 2015 #3

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    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?
     
  5. Feb 17, 2015 #4

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    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.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted



Similar Discussions: Doing a Count in Access 2013 Query -- How to?
  1. Counting Palindromes (Replies: 3)

Loading...