Count records in Parameter Query for Report

[Flopbot]

I know this can be done, but I need some help. In Access ‘03 I have a report
based on “Qry Departmental Hours by Month Parameter LINKâ€. It works fine. I
also have a text box that counts my active volunteers using [
=DCount("[Volunteer ID]","Qry Active Vol LINK") ]. It works fine.

Finally, I have a text box that I want to count the total number of
volunteers who came in during “August 2009â€. It currently uses [
=DCount("[Volunteer ID]","Qry Vol by Month Parameter LINK") ] which does
not work.

In another strain, I read that DCount doesn’t work with parameter queries.
What else should I use instead? I just want the total #, not each individual
record.

 

[KARL DEWEY]

I do believe that you must use the same criteria in the DCount as in your
parameter query.

 

[Flopbot]

Karl,

Thank you for helping. When you say criteria, do you mean the same
underlying query or the same prompt questions? My questions are [What year?]
& [What month?]. When I type in =DCount("[Volunteer ID]","Qry Vol by Month
Parameter LINK") ,which is an identical format to another working textbox,
I get #Error as a result.

I do believe that you must use the same criteria in the DCount as in your
parameter query.
--
Build a little, test a little.

I know this can be done, but I need some help. In Access ‘03 I have a report
based on “Qry Departmental Hours by Month Parameter LINKâ€. It works fine. I
also have a text box that counts my active volunteers using [
=DCount("[Volunteer ID]","Qry Active Vol LINK") ]. It works fine.

Finally, I have a text box that I want to count the total number of
volunteers who came in during “August 2009â€. It currently uses [
=DCount("[Volunteer ID]","Qry Vol by Month Parameter LINK") ] which does
not work.

In another strain, I read that DCount doesn’t work with parameter queries.
What else should I use instead? I just want the total #, not each individual
record.

 

[KARL DEWEY]

I do not know DCount syntax except that it seems you did not have criteria.

--
Build a little, test a little.

Karl,

Thank you for helping. When you say criteria, do you mean the same
underlying query or the same prompt questions? My questions are [What year?]
& [What month?]. When I type in =DCount("[Volunteer ID]","Qry Vol by Month
Parameter LINK") ,which is an identical format to another working textbox,
I get #Error as a result.

I do believe that you must use the same criteria in the DCount as in your
parameter query.
--
Build a little, test a little.

I know this can be done, but I need some help. In Access ‘03 I have a report
based on “Qry Departmental Hours by Month Parameter LINKâ€. It works fine. I
also have a text box that counts my active volunteers using [
=DCount("[Volunteer ID]","Qry Active Vol LINK") ]. It works fine.

Finally, I have a text box that I want to count the total number of
volunteers who came in during “August 2009â€. It currently uses [
=DCount("[Volunteer ID]","Qry Vol by Month Parameter LINK") ] which does
not work.

In another strain, I read that DCount doesn’t work with parameter queries.
What else should I use instead? I just want the total #, not each individual
record.