Duplicate Record in query results - show only once

C

Cait1306

I am running a query based on Lawyers. I have a field of lawyer last names
and a field of lawyer first names - these fields are not selected to "show"
in the query results. They are just there to be sorted alphabetically.
Instead I am concantenating them into a new field to show as Lawyer:
[pfaLawyerFirstName]&" "&[pfaLawyerLastName]. I am trying to find out how
many cases each laywer has managed and the average fee of those cases, so I
also have a CaseID field and a Fee field.

My problem is that each lawyer should only be listed once in the query
results and instead the lawyers name is being listed next to each case they
covered.

How do I get the name to show up only once?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Duplicate hashtags in OneNote 0
Making a report with weak-entity relationships 2
HELP with first time BCM database creation. (Account, BC, Projects 3
Total appointments per agent 2
QBF & Query Malfunction 0
query to show where no data in a stated column 0

Top