Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    COUNT function (2003 SP3)

    Edited by HansV to reduce picture in size - please don't post pictures larger than 640 x 480 pixels.

    Is there anyway to do a COUNT function on the instances of a VALUE in the cell? Basically I'm linked to database and for each field I need the instance of a specific value counted. For example, on the screenshot (attached), in POLLU_ORGAN, I need a count of ONE for Degreaser. Anyway to do this easily?
    Attached Images Attached Images
    • File Type: jpg x.jpg (21.7 KB, 0 views)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: COUNT function (2003 SP3)

    Create a query based on the table.
    Add one of the POLLU... fields to the query grid and also the CASE_NO field.
    Select View | Totals.
    Set the Total option for CASE_NO to Count.
    Switch to datasheet view.
    You'll see the number of occurrances of each value.

    Repeat the above steps for each of the POLLU... fields.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COUNT function (2003 SP3)

    Thank you and apologies for the large pic!

  4. #4
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COUNT function (2003 SP3)

    Using the above steps as a guide, I was able to get the data we need out. One additional question, I've made 'Make-table' queries for everything we need as an output from the database and created reports based on the newly created tables. Is there some way to automate printing or exporting all the reports at once?

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COUNT function (2003 SP3)

    Take a look at Macros in the main Database window (under Table, Queries, etc) or go to View / Database Objects>Macros.

    You can string together actions such as running queries, opening reports, printing reports, etc.

    If you are running Make queries, have your first command be SetWarnings and the "Warnings On" set to No. Have the last command be another SetWarnings that is set to yes. This will turn off (and then back on) the warnings such as "you are going to delete 50 rows..." or "tblYaddaYadda is about to be deleted..."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •