Search results

I looked into it but too complicated for my non-programmer brain :( I've just created a new 'Yes/no' field for whether they are in the research team or not, and gone through and checked each person manually. A rather basic and luddite solution but it does the job. I will mark this thread as...

Nope, all the ID fields are numbers

N.B. is (I thought) a commonly used and understood Latin-derived term, like e.g. and i.e. So many languages and confusions... thanks for your patience with me :D I got rather excited about your piece of code but it returned a 'JOIN expression not supported' message, alas. For transparency, I...

N.B. = An abbreviation for the Latin phrase nota bene, meaning “note well.” It is used to emphasise an important point. All roles are part of the research team! If you have a role, you're part of the team.

Hi plog, Thanks your your response again, much appreciated. Could you explain that a bit more as I'm not clear on the steps. I've clicked Totals/Sigma, which introduces a Total row in the query design. What's the next step? I've tried Group By 'First' but it it still comes up with the same...

Hi plog, So I’ve killed the multi-value field and created a junction table :) Sorry about the confusion with terms, let me try and clarify. I have a contacts table with about 500 people. Within these 500 are 120 people that form the research team. Within this research team of 120 people, there...

Thanks for your response. I guess I have to create a junction table then... I thought multi-value would be quicker/easier. I hear the resounding disapproval! So these are the tables I have: TableContacts ContactID, Name, etc 1, Joe Blogs 2, Mara White 3, Claire Simmons etc TableRoles RoleID...

Apologies for any blundering errors - I am totally new to Access and it's all rather daunting :eek: I've created a contacts database. Some of the contacts belong to a research team. Within the research team there are different roles e.g. NationalPartner InternationalPartner AdvisoryPanel...