Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Specifics (2000)

    Hi, I have a query that lists by name the name of people who have called the office and how many times that person has called. Problem is (I didn't build the database!) that the names of callers are entered in by the user so you could have caller John Jones who has called 4 times then Jon Jones who has contacted 6 times. Jon and John are the same person, unfortunately the first and and last name are in the same field. I have been tasked to find how many times given people have called, there are over 1500 entries and consolidating manually is tedium as you can imagine. Are there any ways I can automate? I have attached my query and the run results on a word document for reference. Many thanks Darren.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Specifics (2000)

    You could try to split the names into first name and last name in a query, and sort on last name, then first name; after that, it's still handiwork.

    But with entries like "Park row (LDS) Jeff Boulton" and "Dominic Stwo at Independent Fin Co" you're going to run into difficulties anyway. It's almost impossible to handle such cases automatically.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Specifics (2000)

    Thanks Hans, thought it would be difficult, I have inherited the database from someone who the company think is the gospel, I know different but office politics and all that!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •