Hide duplicates query - show client totals
I am trying to create a query with client's first and last name, their addresses, city, home phone, and cell phone and 1st date of service. I want the query to only show unduplicated clients; 'First Name' and 'Last Name'; based on their 1st date of service for the current fiscal year July-June.
I also need to have total services for each client calculated... 'Total Trips'
Transportation Field: Total Trips
I will be exporting this info to an excel spreadsheet that will populate that information as it is changed.
Last edited by KHallmark; 07-11-2019 at 09:51 AM.
Reason: Provide info for one table instead of more.