Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    40

    Unanswered: Adding similar numbers in a query

    I am trying to develop a query that will add a field only if the First name and last name is similar. Is this possible? I am getting stumped. WHen I try to add the numbers, it totals and not addes using the critial. Thanks in advance!!

  2. #2
    Join Date
    May 2003
    Posts
    144
    Can you post your query?

  3. #3
    Join Date
    Dec 2003
    Posts
    40
    Sure


    SELECT tblTech.FirstName, tblTech.LastName, tblCalls.ACDANSD
    FROM tblCalls INNER JOIN tblTech ON tblCalls.ID = tblTech.GroupID
    ORDER BY tblCalls.ACDANSD DESC;


    ACDANSD has cells that should be added together where FirstName and LastName Match

Posting Permissions

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