Re: Count Items in a report

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/AwUBRASiBIechKqOuFEgEQL75gCeNx2NlKKONttzPhGEArnxpqA7P4cAn0XQ
ijLTLVfF1J+YChC6hibyUr12
=OpPX
-----END PGP SIGNATURE-----
.

Relevant Pages

  • Re: =Now() Function in Footer
    ... copy and paste into the control source property of the ... textbox and it's still producing an error. ... Did you use square brackets around "Enter Report ...
    (microsoft.public.access.reports)
  • Re: Cant put date on report
    ... a Control source that says =Nowor =Date. ... >stores the Date and Nowstores the Date and Time. ... >> at the bottom of the report. ... I added a textbox with the ...
    (microsoft.public.access.reports)
  • Re: Calculating or making a formula work automatic
    ... I did all the changes on a copy of the database I took home. ... You only can make a report from a querry or a table. ... > Report textbox as you're using in the Form textbox; ... > that you need for a textbox control source; ...
    (microsoft.public.access.gettingstarted)
  • Re: Test for EOF in Report Group Footer
    ... Add a textbox to the detail section of your report. ... Control Source: =Count ... labels in the footer after the last group prints. ...
    (microsoft.public.access.reports)
  • Re: Summing Text Box
    ... >I'm guessing that the textbox showing this is in the ... >StaffTotal are fields in the report. ... >Below the Control Source set the Running Sum to Over All. ...
    (microsoft.public.access.reports)