Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-11-2019, 09:43 AM   #1
KHallmark
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

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 by KHallmark; 07-11-2019 at 09:51 AM. Reason: Provide info for one table instead of more.
KHallmark is offline   Reply With Quote
Old 07-11-2019, 10:02 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,472
Thanks: 58
Thanked 1,416 Times in 1,397 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Hide duplicates query - show client totals

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

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 07-11-2019, 10:17 AM   #3
KHallmark
Newly Registered User
 
Join Date: Jul 2019
Posts: 12
Thanks: 0
Thanked 1 Time in 1 Post
KHallmark is on a distinguished road
Re: Hide duplicates query - show client totals

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

KHallmark is offline   Reply With Quote
Old 07-11-2019, 10:35 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,472
Thanks: 58
Thanked 1,416 Times in 1,397 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Hide duplicates query - show client totals

Quote:
Originally Posted by KHallmark View Post
I don't have enough posts to show the links you posted.
Try this one...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 07-22-2019, 11:36 AM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,303
Thanks: 15
Thanked 1,597 Times in 1,517 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Hide duplicates query - show client totals

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.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Tags
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 01:32 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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