Access 2007 crosstab query

[enia atsir]

Hi,
I have built a cross tab query Account_ID as row heading and month_year as column heading.
I need to find if an account is at one year and not in the next month.For example: 07_2010 is not null, 08_2010 is null, 09_2010 is not null.
I have 30 months in total and is difficult to make all needed combination.
Please can someone help me how to resolve this?
Thnx

[nico5038]

I woldn't use a crosstable query for this.
When you create a table with all Year_Month combination's and LEFT (or RIGHT) JOIN that with the Year_Month combination's in your Account table, a simple "Is Null" test will give the gaps you're looking for.

Nic;o)