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], Muhamed Faisal <[EMAIL PROTECTED]> 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] > 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:[EMAIL PROTECTED] 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=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > [Non-text portions of this message have been removed] >
