In a message dated 10/5/01 1:23:38 PM Eastern Daylight Time, [EMAIL PROTECTED] writes:
> I have forgotten ho 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
