Joining two tables with missing records in one

[Chaman]

I have two tables which I want to merge.

Table 1 has date and expenses as two fields. The table has all 365
days records in it.

Table 2 has fields as date and revenues in region A. Some of the
records may be missing because if there is no revenues genereated on
any given day that day may not have been accounted.

I want to merge these two tables using QUERY such that I have all 365
days in records and it shows corresponding revenues and expenses. If
I use a simple query relating dates in two tables, it merges only the
records which are present in both of the tables but ignores those
which are not present in any of one of these tables.

Any help would be highly appreciated.

Thanks,
Neo

 

[Allen Browne]

You need to use an outer join. To do that, double-click the line joining the
2 tables in the upper pane of query design.

More details:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

 

[Chaman]

Thank you Allen. It worked for me.

You need to use an outer join. To do that, double-click the line joining the
2 tables in the upper pane of query design.

More details:
    The Query Lost My Records!
at:
   http://allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.











- Show quoted text -