Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report Question

Discussion in 'Information Technology' started by JOM, Jul 28, 2006.

  1. JOM

    JOM
    Expand Collapse
    Guest

    My report is a letter that I would like to send to the customers. I have a
    question on the salutation. If there are 2 customers e.g., john smith and
    jane smith, I would like it to say "Dear John and Jane Smith,". If the
    customers names are John Smith and Jane West, then it should say "Dear John
    Smith and Jane West," How will I do that....
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    Do the 2 people (either John and Jane Smith - and - John Smith and Jane West)
    have the same address




    "JOM" wrote:

    > My report is a letter that I would like to send to the customers. I have a
    > question on the salutation. If there are 2 customers e.g., john smith and
    > jane smith, I would like it to say "Dear John and Jane Smith,". If the
    > customers names are John Smith and Jane West, then it should say "Dear John
    > Smith and Jane West," How will I do that....
     
  4. JOM

    JOM
    Expand Collapse
    Guest

    What I provided was just an example, John and Jane Smith are of the same
    address while John smith and Jane west are totally different from John and
    Jane Smith and they don't have the same address as the John and Jane Smith...
    borrower 1 John Smith coborrower 1 Jane Smith
    borrower 2 john smith coborrower 2 jane west



    "Wayne-in-Manchester" wrote:

    > Do the 2 people (either John and Jane Smith - and - John Smith and Jane West)
    > have the same address
    >
    >
    >
    >
    > "JOM" wrote:
    >
    > > My report is a letter that I would like to send to the customers. I have a
    > > question on the salutation. If there are 2 customers e.g., john smith and
    > > jane smith, I would like it to say "Dear John and Jane Smith,". If the
    > > customers names are John Smith and Jane West, then it should say "Dear John
    > > Smith and Jane West," How will I do that....
     
  5. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    No worries. The best bet would be to base your report (or address lables) on
    a query with the address or postcode (zip code in the US) used as the
    summerary field.

    This will provide you with a single address with multiple names (if there
    are more than 1).

    You can than combine the name(s) on the final report or address lable

    Hope this helps




    "JOM" wrote:

    > What I provided was just an example, John and Jane Smith are of the same
    > address while John smith and Jane west are totally different from John and
    > Jane Smith and they don't have the same address as the John and Jane Smith...
    > borrower 1 John Smith coborrower 1 Jane Smith
    > borrower 2 john smith coborrower 2 jane west
    >
    >
    >
    > "Wayne-in-Manchester" wrote:
    >
    > > Do the 2 people (either John and Jane Smith - and - John Smith and Jane West)
    > > have the same address
    > >
    > >
    > >
    > >
    > > "JOM" wrote:
    > >
    > > > My report is a letter that I would like to send to the customers. I have a
    > > > question on the salutation. If there are 2 customers e.g., john smith and
    > > > jane smith, I would like it to say "Dear John and Jane Smith,". If the
    > > > customers names are John Smith and Jane West, then it should say "Dear John
    > > > Smith and Jane West," How will I do that....
     
  6. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Hi JOM -- Assuming the First Name and Last Name are strored in seperate
    fields, you can use the StrComp function to compare the last names. If the
    names are equal, contcatenate the first names and the last name.

    "Wayne-in-Manchester" wrote:

    > No worries. The best bet would be to base your report (or address lables) on
    > a query with the address or postcode (zip code in the US) used as the
    > summerary field.
    >
    > This will provide you with a single address with multiple names (if there
    > are more than 1).
    >
    > You can than combine the name(s) on the final report or address lable
    >
    > Hope this helps
    >
    >
    >
    >
    > "JOM" wrote:
    >
    > > What I provided was just an example, John and Jane Smith are of the same
    > > address while John smith and Jane west are totally different from John and
    > > Jane Smith and they don't have the same address as the John and Jane Smith...
    > > borrower 1 John Smith coborrower 1 Jane Smith
    > > borrower 2 john smith coborrower 2 jane west
    > >
    > >
    > >
    > > "Wayne-in-Manchester" wrote:
    > >
    > > > Do the 2 people (either John and Jane Smith - and - John Smith and Jane West)
    > > > have the same address
    > > >
    > > >
    > > >
    > > >
    > > > "JOM" wrote:
    > > >
    > > > > My report is a letter that I would like to send to the customers. I have a
    > > > > question on the salutation. If there are 2 customers e.g., john smith and
    > > > > jane smith, I would like it to say "Dear John and Jane Smith,". If the
    > > > > customers names are John Smith and Jane West, then it should say "Dear John
    > > > > Smith and Jane West," How will I do that....
     

Share This Page