Multiple Querries

[Jackie]

Hi,

I forgotten to mention that I am using ms access 2002.
Also, when I tried to create a report using the pie graphs
it only sees one result. Why ? but if i do the individual
querries it sees the multiple results, it only happens
when I'm combining all 3 tables. The table with only 1
result seems to dominate the whole thing.

Can someone please explain this.

 

[Van T. Dinh]

It is likely that you use Inner Joins in your Query and an
Inner Join between Table1 and Table2 will only show
Records that exist in BOTH Table1 and Table2. That why
the single-Record Table3 "seems to dominate the whole
thing".

Perhaps, you should read the chapters on Queries in your
Access book(s) so that you have some ideas how basic
Queries should work. Otherwise, it will be very hard for
you to design more complex Queries later.

HTH
Van T. Dinh
MVP (Access)