Search results

Thanks for the quick response Keith! I'm dealing with 6 tables. The 'User' table has a one to many relationship with 'Expertise', 'Collaboration', 'Sabbaticals' and 'Sponsors'. Table: Users Columns: User_ID, First_Name, Last_Name, Email Table: Expertise Columns: Expertise_ID, User_ID...

Table: User Column(s): UserId Table: Classes Column(s): UserId, ClassId User -> Classes is a one to many relationship. In Access is it possible to create a query that outputs 1 record per UserId so that the output would look like: UserId ClassId 102 2...