title: Access 2003: only one result shows in report even though several are in query
body: <p>I have an Access DB, which records hundreds of projects. Each has a priority assigned as well as a project leader.</p>
  
  <p>I have a query which pulls both from this and another table, listing all active projects (excluding closed ones).</p>
  
  <p>Finally, a report uses the query. However, the report refuses to show more than one project which has the same leader and priority. That is, if the same leader has two projects with priority "99" (which means "don't work on this for the foreseeable future"), only the first one shows in the report. (The report is grouped by leader and priority.)</p>
  
  <p>The Priority field is Long Integer and selected by using a lookup to a table of permissible values. It's set to not allow values which aren't in the list.</p>
  
  <p>How can I convince Access to show all matching values from the query? Seems trivial but I'm stumped.</p>
  
  <p>Thanks.</p>