Look into "Union Queries". The basics are such...
Query1 results are... Column1 Column2 Dogs German Shepard Fruits Apples Query2 results are... Column1 Column2 Cars Chevy Homes Duplex The Union Query syntax and results would be... SELECT Column1, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples Cars Chevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Muhamed Faisal <[EMAIL PROTECTED]> To: [email protected] Sent: Saturday, December 29, 2007 5:41:56 AM Subject: [ms_access] query design dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from this two queries.the two queries dont having any connection at all in datas for example in my firest query having two datas and my second query having two datas and if i make third query as my expectation it give 4 datas so how to connect my queries to have two datas only any help pls regards faisal riyadh ------------ --------- --------- --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
