Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-11-2019, 09:43 AM   #1
Newly Registered User
Join Date: Jul 2019
Posts: 12
Thanks: 0
Thanked 1 Time in 1 Post
KHallmark is on a distinguished road
Wink 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.
KHallmark is offline   Reply With Quote

group , hide duplicates , mindate , query

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide duplicates from query ChristopherL Queries 4 08-01-2013 11:37 AM
How to Hide Duplicates in a Query for Just One Field maytime Queries 11 01-20-2012 01:01 PM
Totals from duplicates query Artemis Reports 5 02-09-2010 09:36 AM
Hide Duplicates from Find Duplicate Query cooh23 Queries 2 07-11-2008 08:31 AM
Hide Duplicates within Query frankbutcher Queries 1 07-31-2006 01:21 AM

All times are GMT -8. The time now is 02:51 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World