UPDATE tbl_users SET fullname = 'firstname' & " " & 'lastname'
got an error, something about checking to see if field exists, too few parameters. i tried it with and with out single quotes around the fieldnames. [EMAIL PROTECTED] wrote: > > In a message dated 10/5/01 1:23:38 PM Eastern Daylight Time, > [EMAIL PROTECTED] writes: > > > I have forgotten how to do this... > > > > I have a firstname and a lastname field. i want to create a fullname > > field containing the information. i have done this a long time ago using > > the expression builder to update the field, but must be missing > > something. i was trying, [tbl_users]![firstname] && > > [tbl_users]![lastname] > > UPDATE tbl_users SET fullname = lastname & " " & firstname > > Cheers, > Bill > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
