Report Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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....
 
Do the 2 people (either John and Jane Smith - and - John Smith and Jane West)
have the same address
 
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
 
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
 
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.
 
Back
Top