the database i have is an access database with about 6 tables in it. The table that I want to grab stuff out of is called FullMaster, and I want the columns Fullmaster.nameFirst and FullMaster.nameLast, as well as the custom column to be generated in the select command, or in Access it would be Fullmaster.nameFirst & " " & Fullmaster.nameLast. thanks for the help
On Jun 1, 10:54 pm, Cerebrus <[email protected]> wrote: > In a question about syntax, you should atleast specify the database > system you are working upon. Syntax can vary. > > On Jun 2, 7:19 am, isaac2004 <[email protected]> wrote: > > > 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
