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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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...
 
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
Click to expand...

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]
 
Back
Top