Hide duplicates query - show client totals (1 Viewer)

KHallmark

Registered User.
Local time
Today, 10:29
Joined
Jul 11, 2019
Messages
12
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
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 10:29
Joined
Oct 29, 2018
Messages
21,358
Hi Kim. Welcome to the forum! Should not be a problem but you may have to use a subquery to do it.
 

KHallmark

Registered User.
Local time
Today, 10:29
Joined
Jul 11, 2019
Messages
12
I don't have enough posts to show the links you posted.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:29
Joined
Feb 19, 2002
Messages
42,971
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.
 

Users who are viewing this thread

Top Bottom