Sorry. I hit the send button by mistake. If there are not a lot of columns to convert you could do a union query. Normal query "SELECT COLUMN1, COLUMN2 FROM MYTABLE" Union Query "SELECT COLUMN1 FROM MYTABLE UNION SELECT COLUMN2 FROM MYTABLE" The thing about this is that they have to be the same data type. You may also be able to do a "cross tab" query.
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, Lonnie Johnson <[EMAIL PROTECTED]> wrote: From: Lonnie Johnson <[EMAIL PROTECTED]> Subject: Re: [ms_access] How to get a field value To: [email protected] Date: Thursday, July 3, 2008, 2:56 PM 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]
