Concatenation: based off column

flovettsr

Thread Starter
Joined
Apr 1, 2011
Messages
27
Good Morning,
I have a bit of a challenge. I have a file that shows locations with various tickets for a month.
If a locations has 2 or More Address Names, I need a column that concatenates the Workorder Ticket Numbers
I need the aggregate of the sum of the billing, the sum of the Taxes and the Total Sum, based off the Address Name.
If I add the ticket number to the Query, Each ticket number shows up as a separate row, so I lose the Total Sums I am trying to attain.
I have attached a sample of the source data as well as the desired results.

Thanks.



Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 10 Pro, 64 bit, Build 18362, Installed 20200810004745.000000-300
Processor: Intel(R) Core(TM) i7-8665U CPU @ 1.90GHz, Intel64 Family 6 Model 142 Stepping 12, CPU Count: 8
Total Physical RAM: 32 GB
Graphics Card: DameWare Development Mirror Driver 64-bit
Hard Drives: C: 471 GB (325 GB Free);
Motherboard: Dell Inc. 07WDVW, ver A01, s/n /F7WW4Y2/CNCMK009CC0F9B/
System: Dell Inc., ver DELL - 1072009, s/n F7WW4Y2
Antivirus: Windows Defender, Disabled
 

Attachments

Joined
Sep 21, 2007
Messages
14,582
The list of addresses should exist as a separate table. The sum total of all tickets should exist in a header table. And each ticket should reside as a row in the work order details table. Your tables are not in 3rd normal form. They will give you headaches as you go along.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top