Try this... http://www.tek-tips.com/faqs.cfm?fid=37
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --- On Fri, 7/4/08, Lyanne Rheeza Ong <[EMAIL PROTECTED]> wrote: From: Lyanne Rheeza Ong <[EMAIL PROTECTED]> Subject: Re: [ms_access] How to get a field value To: [email protected] Date: Friday, July 4, 2008, 5:26 AM Yes, it is a value of one field. Yes, it is formatted that way - always separated by 3 commas. L y a n n e R h e e z a C. O n g ----- Original Message ---- From: Lonnie Johnson <[EMAIL PROTECTED] com> To: [EMAIL PROTECTED] ps.com Sent: Friday, July 4, 2008 8:16:24 AM Subject: Re: [ms_access] How to get a field value Ok. Forgive me if I sound dense but AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT" is the value of just one field? Is it always formatted the same way with the two commas separating the three sections? 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] com> wrote: From: Lyanne Rheeza Ong <[EMAIL PROTECTED] com> Subject: Re: [ms_access] How to get a field value To: [EMAIL PROTECTED] ps.com Date: Thursday, July 3, 2008, 7:21 PM AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT" is a field value. Through a select statement, how do I get 'TES_ 1MGMT - ALL_SUBMIT'. To rephrase, how do I get the last value? L y a n n e R h e e z a C. O n g ----- Original Message ---- From: Lonnie Johnson <[EMAIL PROTECTED] com> To: [EMAIL PROTECTED] ps.com Sent: Thursday, July 3, 2008 5:56:57 PM Subject: Re: [ms_access] How to get a field value 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] com> wrote: From: Lyanne Rheeza Ong <[EMAIL PROTECTED] com> Subject: [ms_access] How to get a field value To: [EMAIL PROTECTED] ps.com 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] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
