Merging Data

  • Thread starter Thread starter Eddie Ward
  • Start date Start date
E

Eddie Ward

Just wondered if I could on my recordset merge two data columns on my
cascading combo the sql of the combo is as follows:

SELECT [Company Contacts].CompanyContactID, [Company Contacts].FirstName,
[Company Contacts].LastName
FROM Companies INNER JOIN [Company Contacts] ON Companies.CompanyName =
[Company Contacts].Company
WHERE ((([Company Contacts].Company)=[Forms]![Candidates_View]![Company]))
ORDER BY [Company Contacts].LastName;

But I want the box to display in the drop down a combination of first and
last name and then use this to update the recordset in the candidates table.

Thanks

Ed
 
Use a calculated field to display firstname-lastname combination:

[Company Contacts].FirstName & " " & [Company Contacts].LastName AS Name
 
Where do I add that to the below tho so it's all done in the same field?


Arbo said:
Use a calculated field to display firstname-lastname combination:

[Company Contacts].FirstName & " " & [Company Contacts].LastName AS Name


Eddie Ward said:
Just wondered if I could on my recordset merge two data columns on my
cascading combo the sql of the combo is as follows:

SELECT [Company Contacts].CompanyContactID, [Company Contacts].FirstName,
[Company Contacts].LastName
FROM Companies INNER JOIN [Company Contacts] ON Companies.CompanyName =
[Company Contacts].Company
WHERE ((([Company
Contacts].Company)=[Forms]![Candidates_View]![Company]))
ORDER BY [Company Contacts].LastName;

But I want the box to display in the drop down a combination of first and
last name and then use this to update the recordset in the candidates
table.

Thanks

Ed
Click to expand...
Click to expand...
 
replace columns [Company Contacts].FirstName and [Company
Contacts].LastName with calculated feild. Now you have column 1 as a bound
column and column 2 as a visible description column.

"Eddie Ward" kirjutas:
Where do I add that to the below tho so it's all done in the same field?


Arbo said:
Use a calculated field to display firstname-lastname combination:

[Company Contacts].FirstName & " " & [Company Contacts].LastName AS Name


Eddie Ward said:
Just wondered if I could on my recordset merge two data columns on my
cascading combo the sql of the combo is as follows:

SELECT [Company Contacts].CompanyContactID, [Company Contacts].FirstName,
[Company Contacts].LastName
FROM Companies INNER JOIN [Company Contacts] ON Companies.CompanyName =
[Company Contacts].Company
WHERE ((([Company
Contacts].Company)=[Forms]![Candidates_View]![Company]))
ORDER BY [Company Contacts].LastName;

But I want the box to display in the drop down a combination of first and
last name and then use this to update the recordset in the candidates
table.

Thanks

Ed
Click to expand...
Click to expand...
Click to expand...
 
Back
Top