Counting certain field parameters in a report

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

 

[Guest]

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

 

[Guest]

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

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

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.

 

[Guest]

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

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

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

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.