Combine two queries onto one continuous form.

[Fionn]

Hi,
Is there a way of combining two queries (and sort by some common field: Date) and displaying them on one continuous form. I can't just create a new query because when I create the query with the fields I want it displays no records as none of the records contain all of those fields, if that makes any sense.
Thanks.

[Fionn]

Figured it out. Just had to change the relationship properties between the tables in the query to include all from one table and only matching from the other.