Search results

Yeah, I got that. And created a table, tblCounties, just as you suggested, however, in my form, how can I build it to where a user can enter up to 8 counties that will be tied to that GrantID?

I have a Counties table that lists each County, and associates a DatabaseID with each county. the problem I'm running into is how to link multiple counties to a single grant record, then be able to report on that. I'm confused on how to capture that data efficiently...

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...