You are suppose to have two records if there are two or more unique records.
But, if the fields from the child table (income) that you put onto your grid have the exact same data then you can set the "Unique Values" property to Yes for the query and you will only see one child record with the expense record. 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: Monday, December 31, 2007 11:45:47 PM Subject: Re: [ms_access] query design dear sir i have tried on that way already if we join on that way it is not working because if we have 2 datas in "expense" query and only one data in "income" query then the final query dublicating one value for "income" query this is my problem pls help to solve this regrds faisal riyadh ----- Original Message ---- From: Lonnie Johnson <[EMAIL PROTECTED] com> To: [EMAIL PROTECTED] ps.com Sent: Monday, December 31, 2007 10:35:59 PM Subject: Re: [ms_access] query design I looked at your database and the query you had. You need to join the two tables by the field "custmer". In the design view of the query click down on the field name in the table object in the expense table and drag it over to the same field name in the income table and let go. There should be a line between the two tables. For more information look up "joins" in the help section. 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; [EMAIL PROTECTED] com Sent: Monday, December 31, 2007 6:29:17 AM Subject: Re: [ms_access] query design 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] com> To: [EMAIL PROTECTED] ps.com 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] ____________ _________ _________ _________ _________ _________ _ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ [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]
