dear khalid pls see attahed data base sample
here you can see two table and one query actually i need to bring complete information from two table to one query for making a report if you open income table there is two data with customer name as "sagp" and from expese table one data with customer name as "sagp" and in query all i select all filed from both table and it result dublicating one value from expese table this is my problem hoping any sujestion from you reagrds faisal riyadh ----- Original Message ---- From: Khalid (Mohd. Shareef) Arramli <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, January 15, 2008 8:33:17 AM Subject: [ms_access] Re: report design Faisal, Create a third with the fields that you want to collect from both then setup your criteria in a code to collect data and isert them in the third table. If you can't do it send me a copy and I'll see what I can do. Regards, Khalid Arramli why do not you upload the database & I'll if I could --- In [EMAIL PROTECTED] ps.com, Muhamed Faisal <muhamed_faisal2000 @...> wrote: > > sir, > > if we done so some record is dublicating because of there is no connection in the table > > eg. if we have two data in first table and only one data in second table then new query will dublicate one value for second table > > how to solve this > > regards > faisal > riyadh > > > > > ----- Original Message ---- > From: Khalid Arramli <[EMAIL PROTECTED] .> > To: [EMAIL PROTECTED] ps.com > Sent: Sunday, January 13, 2008 3:24:25 PM > Subject: RE: [ms_access] report design > > Faisal, > > You can by creating a query joining both tables. > > Regards, > > Khalid Arramli > > From: [EMAIL PROTECTED] ps.com [mailto:ms_access@ yahoogrou ps.com] On Behalf > Of Muhamed Faisal > Sent: Sunday, January 13, 2008 2:04 PM > To: [EMAIL PROTECTED] ps.com > Subject: [ms_access] report design > > dears > > i have two tables with 3 field and another table with 4 field > now i want to make a report in which all my data from these two table is > dispalyed > both tables is dont have any connection at all > > how it is possible > > expecting any tips > > regards > > faisal > riyadh > > ____________ _________ _________ _________ _________ _________ _ > 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] > > [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] > ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
