This is probally a newb question

[tdanko128]

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

[RuralGuy]

Use Left Joins instead of INNER Joins.

[tdanko128]

Thanks Work Great!

[RuralGuy]

Great! Are you ready to use the Thread Tools and mark this thread as Solved?

[tdanko128]

I was About too ask How to do that. I'm new to this forum. Thanks