Combining Columns

[greysquirl]

The SQL below is what I am currently using. What I am wanting to do; if possible; is from the "Review" table I want to have a first name (FName) middle initial (MI) and last name (LName). When this query runs I want it to take the three and combine them into one column (Name) in the "Position Change" table. Is this possible?

INSERT INTO [Position Change] ( Position, DateStarted, Name, Department, EmpID )
SELECT Review.Position, Review.[Position Start], Review.Name, Review.Department, Review.EmpID
FROM Review
WHERE Review.EmpID = Forms!Review!EmpID
ORDER BY Review.EmpID;

 

[tlbroadbent]

You can concatenate the columns.

Review.FName & " " & Review.MI & " " & Review.LName Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

insert into [Position Change] ( ..., name, ....)
select ...., FName + " " + MI + " " + LName, .... from .... John Fill

ivfmd@mail.md