469,610 Members | 1,494 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Count Items in a report

I have a parameter query to filter by date from which I run a report. I
need to be able to count the number of times a particular product or
error type appears after the report is run from the query. The products
and error types are limited to a defined list. I need to put these
summary totals in the footer. Using the Dcount function works, but
returns all items, not those within the date range.
Any assistance would be appreciated.

Miguel

Feb 28 '06 #1
3 4145
Miguel wrote:
I have a parameter query to filter by date from which I run a report. I
need to be able to count the number of times a particular product or
error type appears after the report is run from the query. The products
and error types are limited to a defined list. I need to put these
summary totals in the footer. Using the Dcount function works, but
returns all items, not those within the date range.
Any assistance would be appreciated.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can use a running sum control in the report and the IIf() function
to count specific products & "error types." E.g.:

Set up a TextBox in the Detail section (or whichever section you are
placing the product/error type data) w/ the Running Sum property set to
Over All. Then set the Control Source property to something like this:

=IIf([product]="ironing board",1,0)

Name this control something like txtIroningBoardCount. You can set it's
Visible property to No.

In the Report Footer put another TextBox with the Control Source set to:

=txtIroningBoardCount

This TextBox will show the total count of all ironing boards in the
report. Label it something like "Ironing Boards: ".

Do the same for all other items you want to count.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRASiBIechKqOuFEgEQL75gCeNx2NlKKONttzPhGEArnxpq A7P4cAn0XQ
ijLTLVfF1J+YChC6hibyUr12
=OpPX
-----END PGP SIGNATURE-----
Feb 28 '06 #2
Many thanks. I will try this out.

Mar 6 '06 #3
I followed your advice and it worked perfectly. Thank you.
Miguel

Mar 8 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.