Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a report where I reflect the details from Table 1 & Table 2. I have two tables that reflect the same data but with a slight variation. In the Table 1, the persons name appears as first name, and surname as individual fields. In Table 2, the same person will appear as the the first name and surname combined however limited to 29 or 30 characters. How would I match the data correctly or link it together so that the same person may exist as one record in a report.
Example:
Table 1
First name: Barry Roland James Porter Ta
Surname: Anastasia
Table 2:
Agent: Barry Roland James Porter Ta A
hi musta
concat two fields in table1
Load
First name & left(Surname,1) as Agent
fom xxx
Regards
Ashfaq
Hi,
Create another field in you Table 1 which has Firstname and surname Concatenated and upto 25 or 30 (depending on the size of your Agent Field)characters. Eg:
Tab1:
Load
First Name,
Surname,
Left(Firstname&Surname,25) as Agent
Tab2:
Load
Agent