combining 2 queries using "OR" between the fields

[Liat]

Hi,

I have 2 queries on dates - one for "estimation" table
and the other is for "payments" table.

I would like to create a query that gives all the
estimations and payments in the given dates, ie that
combines those 2 queries using "or".

When I tried to creat a query that contains the main
table and those 2 queries that are linked to the main
table using ID field, the query showd only records that
have BOTH estimations and payments in the given range of
dates. I would like the record to be shown if there is
only estimation without payment or the opposites.

How can it be done?

Thanks in advance,
Liat

 

[[MVP] S.Clark]

An outer join always for the showing of ALL data from one table, as well as
any matching data from the other linked table.

If you double click on the link between the two tables, you can modify the
query from an inner to an outer join.