dear sir pls see my sample database which have two table names expense and income now i want to get a new query in which i expect datas from two tables like customer name,expense value,expense details,invoice number from expense and income value,income details,date from income but i have only one data in income and two data in expense but my query showing 4 anwers so please tell me the way of connecting two queries two get corect result+
hope you understand the problem of mine regards faisal riyadh ----- Original Message ---- From: Lonnie Johnson <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, December 31, 2007 12:24:13 AM Subject: Re: [ms_access] query design When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? 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 <muhamed_faisal2000@ yahoo.com> To: [EMAIL PROTECTED] ps.com Sent: Sunday, December 30, 2007 12:12:26 AM Subject: Re: [ms_access] query design dear sir thank for your reply but in union query all of our connected qiery field should be in identical but in my cases both queries datas are not identical hope you understand my problem any tips pls regrds faisal riyadh ----- Original Message ---- From: Lonnie Johnson <[EMAIL PROTECTED] com> To: [EMAIL PROTECTED] ps.com Sent: Saturday, December 29, 2007 3:26:06 PM Subject: Re: [ms_access] query design 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 <muhamed_faisal2000 @ yahoo.com> To: [EMAIL PROTECTED] ps.com 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] ____________ _________ _________ _________ _________ _________ _ 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] ____________ _________ _________ _________ _________ _________ _ 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] ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
