Look at MS Access help at the "cross tab query". This may be what you are looking for.
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --- On Sat, 6/14/08, Muhamed Faisal <[EMAIL PROTECTED]> wrote: From: Muhamed Faisal <[EMAIL PROTECTED]> Subject: [ms_access] query help To: [email protected] Date: Saturday, June 14, 2008, 9:09 PM DEARS I have a query having filed name factories in text data type and result of query like follows Plant A Plant B Plant C Plant D Now form above query i want to make a new query which result is Plant A & Plant B & Plant C & Plant D How it is possible Hoping Any tips regards Faisal Riyadh [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
