Show field heading <> in report (1 Viewer)

wasim_sono

Registered User.
Local time
Today, 20:56
Joined
May 29, 2008
Messages
33
wasimssgc
I have a crosstab query like
Code:
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?
 

Attachments

  • doc1.xlsx
    111.3 KB · Views: 71

theDBguy

I’m here to help
Staff member
Local time
Today, 09:56
Joined
Oct 29, 2018
Messages
21,468
Hi. Not sure, but you could try using the Nz() function to replace Null values with something you could use as a column heading.
 

Users who are viewing this thread

Top Bottom