How to display <> filed of crosstab query into report?

[WasimSSG]

I have a crosstab query like

TRANSFORM Count(Trans_tbl_dom.consumer_no) AS CountOfconsumer_no1
SELECT Q_Img_Summary_code2_dom_1.Area, Q_Img_Summary_code2_dom_1.book, Q_Img_Summary_code2_dom_1.CountOfconsumer_no AS [Total Customers], Q_Img_summary_code2_dom_2.[Accurate / Only index], Q_Img_summary_code2_dom_2.[No image]
FROM Trans_tbl_dom INNER JOIN (Q_Img_Summary_code2_dom_1 INNER JOIN Q_Img_summary_code2_dom_2 ON (Q_Img_Summary_code2_dom_1.book = Q_Img_summary_code2_dom_2.book) AND (Q_Img_Summary_code2_dom_1.Area = Q_Img_summary_code2_dom_2.Area)) ON (Trans_tbl_dom.book = Q_Img_summary_code2_dom_2.book) AND (Trans_tbl_dom.Area = Q_Img_summary_code2_dom_2.Area)
WHERE (((Trans_tbl_dom.Pic_status)=8))
GROUP BY Q_Img_Summary_code2_dom_1.Area, Q_Img_Summary_code2_dom_1.book, Q_Img_Summary_code2_dom_1.CountOfconsumer_no, Q_Img_summary_code2_dom_2.[Accurate / Only index], Q_Img_summary_code2_dom_2.[No image], Trans_tbl_dom.Pic_status
PIVOT Trans_tbl_dom.[2nd_code];

It shows a field with heading <> which has null data.

but when I use "coulumn heading" in property sheet what heading should I to use?

Please view attachment for details.

 

[dhookom]

Apparently there are nulls/blanks in the pivot field Trans_tbl_dom.[2nd_code]. How about trying to change it to something like:

Nz(Trans_tbl_dom.[2nd_code],"NA")

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016