Recent content by ipr

Got it working. Thanks guys!

I'm relatively new to Access. I think I know what that means, but please explain to me how to do that. I tried to make the query the Control Source for each checkbox but no options appeared in the Control Source dropdown menu

But wouldn't that require me to put multiple values in one value field, i.e. tblFacultyInterests FacultyID [1] InterestID [1, 3] to represent Larry Miller, Blue, Green ??

I asked this in Queries before, but I think my problem is of a different nature now. My database is meant for faculty members at my university to scout out potential research partners with similar interests. I have a table with faculty members' names, and then a list of about 54 keywords...

By "characteristic" do you mean "keyword"? When I have my query results, only the faculty ID number should be displayed next to the list of keywords, not their name? And then the query would run JUST on the keywords? Is this what you are telling me? I do have a different, master table with...

My database is meant for faculty members at my university to scout out potential research partners with similar interests. I have a table with faculty members' names, and then a list of about 54 keywords which might be applicable to that faculty member's research. Each keyword is its own field...

I'm a student at Northwestern University. I work for the Institute of Policy Research, which coordinates affiliated faculty research projects. I created and manage a database which faculty will use to look up potential research partners with similar interests and areas of expertise, access...