If there are not a lot of columns to convert you could do a union query. Normal query "SELECT "
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]
