Not sure what you mean here. Is AddUserToUserClass a table or query? What do you mean by a sample field?
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --- On Thu, 7/3/08, Lyanne Rheeza Ong <[EMAIL PROTECTED]> wrote: From: Lyanne Rheeza Ong <[EMAIL PROTECTED]> Subject: [ms_access] How to get a field value To: [email protected] Date: Thursday, July 3, 2008, 12:43 PM Hello, In a select statement, how do you get the value of "TES_1MGMT - ALL_SUBMIT" from a sample field value of AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT". Thanks L y a n n e R h e e z a C. O n g [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
