Faisal, Please upload the database to the site for everyone to review.
Regards, Khalid Arramli --- In [email protected], Muhamed Faisal <[EMAIL PROTECTED]> wrote: > > 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 <karramli@ .> > > 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] >
