Hide duplicates query - show client totals

[KHallmark]

Hello,

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.
-Kim

 

[theDBguy]

Hi Kim. Welcome to the forum! Should not be a problem but you may have to use a subquery to do it.

 

[KHallmark]

I don't have enough posts to show the links you posted.

 

[theDBguy]

I don't have enough posts to show the links you posted.

Try this one...

 

[Pat Hartman]

This is a problem for a report with a subreport. The main report shows only the clients and the subreport shows the details and the summary. Or, if you don't actually want to see the detail but just want to see the total, then turn the query into a Totals query.