I have this query:

Code:
SELECT projects.id, projects.proj_name, items.item, items.date_entered, users.first_name, users.last_name, users.Active
FROM ([SELECT users_project.proj_id
FROM users_project
WHERE (users_project.users_id=1)]. AS x INNER JOIN projects ON x.proj_id = projects.id) INNER JOIN (users INNER JOIN items ON users.id = items.users_id) ON projects.id = items.projects_id
GROUP BY projects.id, projects.proj_name, items.item, items.date_entered, users.first_name, users.last_name, users.Active
HAVING (((items.date_entered) Not Between (Date()-Weekday(Date())+1) And (Date()-Weekday(Date())+7)))
ORDER BY users.last_name;
It gives me this result:

Project 1 This is item 1 proj1 11/4/2011 Tom Jones
Project 1 This is item 2 proj 1 11/4/2011 Tom Jones
Project 2 This is item 4 proj 2 11/5/2011 Tom Jones
Project 3 This is item 7 proj 3 11/4/2011 Tom Jones
Project 1 This is item 6 proj 1 11/5/2011 Harry Smith

I just need a row per each person, so in this case just two rows. How do I modify the query to do this? Any help is appreciated. THanks