I am working on a report with various levels of headers and footers. I have one footer based on Location, which is counting the ID numbers for each field that is in that Location like this:
=Count([CategoryID]) (the field is named txtCntCategoryID)
As you can imagine this Footer gives me summary data for each clinic. At the end, I want it to Sum the counts for each group of clinics (ex...PC Green 1, PC Green 2, PC Green 3 are all clinics in PC Green. To accomplish this, in the next (lower) footer (Date), I am trying to Sum all the Counts from the above (Location) footer as follows:
=DSum("[txtSumCategoryID]","rptPatientContacts","[txtLocation] Like '*PC Green*'")
(I am looking for the sum of all the counts for Locations that include the text "PC Green"..."txtLocation" is a field in the Location Header...I have also tried it in the footer.)
However, every time I run it I get "#Error". Is this an inappropriate way to use DSum to reference another field within the same report?
Thanks for your help!
=Count([CategoryID]) (the field is named txtCntCategoryID)
As you can imagine this Footer gives me summary data for each clinic. At the end, I want it to Sum the counts for each group of clinics (ex...PC Green 1, PC Green 2, PC Green 3 are all clinics in PC Green. To accomplish this, in the next (lower) footer (Date), I am trying to Sum all the Counts from the above (Location) footer as follows:
=DSum("[txtSumCategoryID]","rptPatientContacts","[txtLocation] Like '*PC Green*'")
(I am looking for the sum of all the counts for Locations that include the text "PC Green"..."txtLocation" is a field in the Location Header...I have also tried it in the footer.)
However, every time I run it I get "#Error". Is this an inappropriate way to use DSum to reference another field within the same report?
Thanks for your help!
