Search results

I solved this with adding the "Count" function into the query: SELECT Alumni.Last, Alumni.SeminarName, Alumni.Staffers2 FROM SeminarStaffers INNER JOIN Alumni ON SeminarStaffers.ID = Alumni.Staffers2.Value GROUP BY Alumni.Last, Alumni.SeminarName, SeminarStaffers.StafferName HAVING...

Hi Ranman256, So it's not possible to do this using the current database structure? I was thinking it might be possible to use a query that includes counting the length of the lists in Alumni.Staffers2 and only include lists of length 1 in the query result. Thanks!

I have a database with two related tables that I'm working to query. The tables are "Alumni" and "SeminarStaffers". The "Alumni" table has a multiselect listbox that allows input of multiple staffers from the "SeminarStaffers" table. The "SeminarStaffers" table looks like this: ID...

Hello, Thanks for allowing me access to your community. I'm not new to Microsoft Access but I'm not a very experienced programmer. I'm involved in international project evaluation. I currently live in the US but I've lived in several countries around the world, in Europe, Africa, and Asia...