I have the following table in Access 2000<BR><BR>Employee<BR>Employee_ID, Lastname, FirstName<BR><BR>Assets<BR>Asset_ID, Description, Employee_ID<BR><BR>I need to select all the Assets for the employee and group by Employee&#039s lastname. Please help me with the following code..<BR><BR><BR>"Select employee.Lastname,Assets.AssetDesc from Assets INNER JOIN [Employee] ON Assets.EmployeeID = Employee.EmployeeID" <BR><BR>This pulls up employee&#039s last name for every asset.<BR>I am just learning and any help would be greatly appreciated....!<BR>thanks!!