Ok so I Have a data base with three tables for tracking bills.
Companies:
Accounts:
Payments:
I'm trying to run a query with Information from all three tables.
So I went to the query design and dragged my fields in and it worked fine Except one thing. If their is no Payment record created for the Associated account it does not pull up the account or company information in the query. What I would like is to still be able to see companies and accounts even if the payment fields in the query are empty.
Any Help Would Be Greatly Appreciated