Sorry. I answered the wrong post before. 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, Ime Asangansi <[EMAIL PROTECTED]> wrote: From: Ime Asangansi <[EMAIL PROTECTED]> Subject: [ms_access] convert columns to rows To: [email protected] Date: Thursday, July 3, 2008, 12:08 PM Hi all, Please can someone kindly show how to use a query to convert columns to rows? Thanks a lot, in anticipation Ime [Non-text portions of this message have been removed]
