hello, i am trying to implement a statement that creates a custom column. here is the statement
strSQL = "SELECT FullMaster.nameFirst, FullMaster.nameLast, '[FullMaster]! [nameFirst] & ' ' & [FullMaster]! [nameLast]' AS Expr1 FROM FullMaster;"; what i am trying to do is concatenate two records and put them into the new column. this will be used on a search results page that will return a full name based on a partial or full name implemented Example if a user enters in Joe Bill, i want the results page to display that. since i dont have a full name column to begin with, it does not work. how do i get the expression into the string with the proper syntax. thanks for the help
