Hello,
I cannot for the life of me figure out how to get a report I'm working on to count fields that contain specific text.
For example, I am trying to build a report that will count the number of grants within a county. Lets use "Mason" county as an example.
I have Fields 1-8 that capture "County", "County2", "County3" etc. all the way to "County8". Each county could have the capability of listing a single one of Michigan's 83 counties. A record could look like:
Then the next record could only have 1 county, that being Mason.
How can i create a field in a report that will look through all 8 "County" fields and count the number of instances that "Mason" is in there, or "Saginaw" or whatever the county I need may be.
ultimately, I need the report to list every county in Michigan, and show the number of associated grants with it.
I know, clear as mud. but help... please
I cannot for the life of me figure out how to get a report I'm working on to count fields that contain specific text.
For example, I am trying to build a report that will count the number of grants within a county. Lets use "Mason" county as an example.
I have Fields 1-8 that capture "County", "County2", "County3" etc. all the way to "County8". Each county could have the capability of listing a single one of Michigan's 83 counties. A record could look like:
- County - Monroe
- County2 - Mason
- Couunty3 - Saginaw
Then the next record could only have 1 county, that being Mason.
How can i create a field in a report that will look through all 8 "County" fields and count the number of instances that "Mason" is in there, or "Saginaw" or whatever the county I need may be.
ultimately, I need the report to list every county in Michigan, and show the number of associated grants with it.
I know, clear as mud. but help... please