big project need to add and delete

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: ksnapp (ksnapp.136pcs_at_excelforum-nospam.com)
Date: 03/16/04 

Date: Mon, 15 Mar 2004 18:06:30 -0600

here is a sample of my data:

client name disctirpion #
client 1 Orders 7
        Deliveries 1
        Item 4
        Payments 4
        Payments 0
        TOTAL TRANSACTIONS 9
client 2 Orders 69
        Deliveries 8
        Item 15
        Payments 6
        Payments 56
        Item 1
        Deliveries 1
        Payments 2
        Payments 3
        Payments 1
        TOTAL TRANSACTIONS 86
client 3 Orders 2710
        Deliveries 45
        Item 505
        Payments 21
        TOTAL TRANSACTIONS 571
client 4 Orders 50
        Orders 74
        Deliveries 1
        Item 1
        Payments 9
        Payments 2
        TOTAL TRANSACTIONS 13
client 5 Orders 15
        Deliveries 20
        Item 72
        Payments 1
        Deliveries 0
        TOTAL TRANSACTIONS 93

I have tried to skin this cat several different ways and can't do it
correctly.

What I need to accomplish is this:

for each client I need to have only one of each discription If there
is more than one i need to show the sum of the values in the first
entry and then delete any others that follow.

Any Ideas would be greatly appreciated 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: Ooops
    ... We need to see the code you're trying to use to accomplish this. ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000/2003 ...
    (microsoft.public.access.forms)
  • Re: Identifying row in Calendar Control
    ... exactly what you were trying to accomplish perhaps we could help. ... There's ALWAYS more than one way to skin a cat! ... Answers/posts based on Access 2000/2003 ...
    (microsoft.public.access.forms)
  • Re: OT : How To Give Your Pet A Pill
    ... >> Then there's the outside cat, named the Yellow Cat. ... >> head and neck was a 4-inch flap of dead skin and putrefied flesh. ... >> he was still alive in the morning, I'd take him to the vet. ...
    (alt.support.mult-sclerosis)
  • Re: OT : How To Give Your Pet A Pill
    ... > Then there's the outside cat, named the Yellow Cat. ... > head and neck was a 4-inch flap of dead skin and putrefied flesh. ... > he was still alive in the morning, I'd take him to the vet. ...
    (alt.support.mult-sclerosis)
  • Re: OT : How To Give Your Pet A Pill
    ... Then there's the outside cat, named the Yellow Cat. ... head and neck was a 4-inch flap of dead skin and putrefied flesh. ... he was still alive in the morning, I'd take him to the vet. ...
    (alt.support.mult-sclerosis)