Allow Zero to Display in Query

[pianoprodigy]

I am doing this query at work which tracks referrals sent out of our office.

I have 7 queries that first isolate the month(s) of data (six months individually back, and one six-month total).

I then have 7 other queries which isolate two fields in order to count the number of referrals to each Firm Grouped By the Firm.

These all work fine; however, when I place all seven of the "Count" fields of these queries into a Main query and run the query, only three records show up. I figured out that in order for this "Main" query to display the Firm, it needs to have at least one referral each month. The three records which show up all have at least one referral for each month.

The Datasheet view of the query displays eight columns. The last column is the six-month total (which of course would include every possible Firm which would need to be included). Is there a way to make the query display all of those firm names and then the "Count" data for each month regardless if it is "0" or "72"?

Thanks in advance,

Alan

 

[FoFa]

It sounds like you are INNER JOINING the tables/queries so that something HAS to exist in the joined tables for it to return data. Maybe you should use a UNION query instead. From your description it does not sound like out joins will fit the bill either.