Hi, I'm using CF5. I have a access database with one table. That table contains rows with all of the states, cities, zip codes, and counties. I'm trying to figure the best way to list the state name, and then the number of counties and number of zipcodes in the state.
Output would look like:
State: Florida
Counties: (however many)
Zip Codes: (however many)
Output would continue for each state.
I gouped the state in my ouptut, and that part came out right, but I don't know how to group or loop through to see how many records contain the county and zip code part. Any help getting me going in the right direction would be appreciated.
Output would look like:
State: Florida
Counties: (however many)
Zip Codes: (however many)
Output would continue for each state.
I gouped the state in my ouptut, and that part came out right, but I don't know how to group or loop through to see how many records contain the county and zip code part. Any help getting me going in the right direction would be appreciated.