How to show records which has no transaction in an action query?

[Guest]

I have an access query that does not show records that have transactions for
periods specified e.g If there are no transactions for January, no records
will be show even if there is an openning balance for January. I will
greatful if am helped to solve that problem.

Regards

 

[Patrice]

What is the "opening balance" ? More generally sometimes, we create a month
table that contains all months in the year allowing to show data for all
months even if there is no data for a particular month. This table could
perhaps play this role. Else just create a separate period table...

 

[John Vinson]

I have an access query that does not show records that have transactions for
periods specified e.g If there are no transactions for January, no records
will be show even if there is an openning balance for January. I will
greatful if am helped to solve that problem.

Regards

What's the structure of your table, or tables? Where is the "opening
balance" shown?

I'm guessing (in the dark) that you may need an Outer Join in the
query.

John W. Vinson[MVP]