Difficult User Requirement - Appending Blank Columns

[dark.matter]

you're always going to have a 'blank' line in this query but you can remove it by building another query based on the crosstab query and put is not null in the itemno column.

I am almost done with the form. But as you said there is a blank line in the crosstab query. I built another query on this one by writing 'Is Not NULL' in Item No. Criteria (Design View). The blank line went away along with the blank years. What is the problem with this?

[Dal Jeanis]

rpeare's going to have to answer that one - I don't know precisely what he meant by "another query based on the crosstab query", and how that would work. You might be able to use NZ(qty,0), but then you'd get zeroes instead of blanks.

[rpeare]

Assuming you followed my example and created the crosstab, name that crosstab qryCrosstab then make this query:

SELECT qryCrosstab.ItemNo, qryCrosstab.[2010], qryCrosstab.[2011], qryCrosstab.[2012], qryCrosstab.[2013]
FROM qryCrosstab
WHERE (((qryCrosstab.ItemNo) Is Not Null))