Access VBA: Crosstab Tables into Forms, deleting blanks

[derekben]

I have a crosstab table that is displaying in a form within a form because the form has data coming from multiple tables.



Crosstab Query looks like
Name Sum Cust1 Cust2 Cust3.....
Jon 50 250


Bill 100 50 100
Kevin 200 50 100
Ryan 10 500

The issue are the blanks in the rows for each Name. When I bring it up on the form, I want the columns to be the Customers but only customers with amounts. The original form is there to show the name and position and the form within the form should have 1 row for name of the person that is being selected and columns of customers WITH A BALANCE. THANKS !!!!!

[TG_W]

If you have not already, add a field for outstanding balance, and include "Is Not Null" in the query for that field.