Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Counting certain field parameters in a report

Discussion in 'Information Technology' started by Groundhog, Jul 28, 2006.

  1. Groundhog

    Groundhog
    Expand Collapse
    Guest

    This should be an easy one but I've been working it for a week and...well...I
    guess I need a more current Access For Dummies Book. What I need to know is
    this:

    IS THERE A WAY OF PUTTING A COUNT FEATURE IN A REPORT THAT JUST COUNTS
    RECORDS THAT MATCH A CERTAIN CRITERIA.

    I have a database that tracks our help desk tickets and I'm trying to build
    a daily summary report. I have the records grouped on the correct field, (in
    this case it's the STATUS field) the problem is that it gives me the summary
    of EVERY entry in that field. I just want to get a count of records where
    STATUS = RESOLVED. Is there a way of limiting the count to a certain
    criteria like this?

    ***BONUS QUESTION***
    If this is possible that let me take it one step further. Is there a way of
    putting a count feature in a report that counts records where two fields have
    to match a certain criteria.

    For you oldsters out there who remember DBase III/IV, it would be something
    similar to the command COUNT FOR CATEGORY = ACTIVE .AND. STATUS = RESOLVED.
     
  2. Loading...

    Similar Threads Forum Date
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    Malaysia Malaysian 2013 Election - Vote Counting Underway Breaking News May 5, 2013
    No Counting Allowed in Gurmatt Jap Ji Sahib Dec 15, 2012
    Christianity Ye Olde King James Version, 400 Years and Counting Interfaith Dialogues Mar 27, 2011
    Will counting caste help to reduce inequality? Hard Talk May 11, 2010

  3. David Widener

    David Widener
    Expand Collapse
    Guest

    Create a text box on the report and put =Count([AssetNumber]) in the
    control source properties

    "Groundhog" wrote:

    > This should be an easy one but I've been working it for a week and...well...I
    > guess I need a more current Access For Dummies Book. What I need to know is
    > this:
    >
    > IS THERE A WAY OF PUTTING A COUNT FEATURE IN A REPORT THAT JUST COUNTS
    > RECORDS THAT MATCH A CERTAIN CRITERIA.
    >
    > I have a database that tracks our help desk tickets and I'm trying to build
    > a daily summary report. I have the records grouped on the correct field, (in
    > this case it's the STATUS field) the problem is that it gives me the summary
    > of EVERY entry in that field. I just want to get a count of records where
    > STATUS = RESOLVED. Is there a way of limiting the count to a certain
    > criteria like this?
    >
    > ***BONUS QUESTION***
    > If this is possible that let me take it one step further. Is there a way of
    > putting a count feature in a report that counts records where two fields have
    > to match a certain criteria.
    >
    > For you oldsters out there who remember DBase III/IV, it would be something
    > similar to the command COUNT FOR CATEGORY = ACTIVE .AND. STATUS = RESOLVED.
    >
     
  4. Groundhog

    Groundhog
    Expand Collapse
    Guest

    What does ([AssetNumber]) represent? Could you be a little clearer.

    "David Widener" wrote:

    > Create a text box on the report and put =Count([AssetNumber]) in the
    > control source properties
    >
    > "Groundhog" wrote:
    >
    > > This should be an easy one but I've been working it for a week and...well...I
    > > guess I need a more current Access For Dummies Book. What I need to know is
    > > this:
    > >
    > > IS THERE A WAY OF PUTTING A COUNT FEATURE IN A REPORT THAT JUST COUNTS
    > > RECORDS THAT MATCH A CERTAIN CRITERIA.
    > >
    > > I have a database that tracks our help desk tickets and I'm trying to build
    > > a daily summary report. I have the records grouped on the correct field, (in
    > > this case it's the STATUS field) the problem is that it gives me the summary
    > > of EVERY entry in that field. I just want to get a count of records where
    > > STATUS = RESOLVED. Is there a way of limiting the count to a certain
    > > criteria like this?
    > >
    > > ***BONUS QUESTION***
    > > If this is possible that let me take it one step further. Is there a way of
    > > putting a count feature in a report that counts records where two fields have
    > > to match a certain criteria.
    > >
    > > For you oldsters out there who remember DBase III/IV, it would be something
    > > similar to the command COUNT FOR CATEGORY = ACTIVE .AND. STATUS = RESOLVED.
    > >
     
  5. David Widener

    David Widener
    Expand Collapse
    Guest

    AssetNumber is the field name of the records I am counting so how about
    =Count([FieldName])

    "Groundhog" wrote:

    > What does ([AssetNumber]) represent? Could you be a little clearer.
    >
    > "David Widener" wrote:
    >
    > > Create a text box on the report and put =Count([AssetNumber]) in the
    > > control source properties
    > >
    > > "Groundhog" wrote:
    > >
    > > > This should be an easy one but I've been working it for a week and...well...I
    > > > guess I need a more current Access For Dummies Book. What I need to know is
    > > > this:
    > > >
    > > > IS THERE A WAY OF PUTTING A COUNT FEATURE IN A REPORT THAT JUST COUNTS
    > > > RECORDS THAT MATCH A CERTAIN CRITERIA.
    > > >
    > > > I have a database that tracks our help desk tickets and I'm trying to build
    > > > a daily summary report. I have the records grouped on the correct field, (in
    > > > this case it's the STATUS field) the problem is that it gives me the summary
    > > > of EVERY entry in that field. I just want to get a count of records where
    > > > STATUS = RESOLVED. Is there a way of limiting the count to a certain
    > > > criteria like this?
    > > >
    > > > ***BONUS QUESTION***
    > > > If this is possible that let me take it one step further. Is there a way of
    > > > putting a count feature in a report that counts records where two fields have
    > > > to match a certain criteria.
    > > >
    > > > For you oldsters out there who remember DBase III/IV, it would be something
    > > > similar to the command COUNT FOR CATEGORY = ACTIVE .AND. STATUS = RESOLVED.
    > > >
     

Share This Page