Dear khalid
pls advice how upload this data base so that every one can review
faisal
"Khalid (Mohd. Shareef) Arramli" <[EMAIL PROTECTED]> wrote:
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]
>
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
[Non-text portions of this message have been removed]
