Missing record source

[M.A.Halim]

I have a crosstab Qry that has the month numbers (1 to 12) as column
headings. this Qry is feeding a report. The report has the 12 months of the
year in the details section in text boxes . The issue here is when i Display
the sales of some branches, and those branches are newly opened so the don't
have full year history but the report still has the 12 months in the text
boxes. For Example the branch started business on June so the report gives an
error saying {can't recognise the Month number which is Jan for example
because it comes first} since the record source of Jan does not exist. how
can I overcome this issue? I want it to display the missing months as "0" or
null and show the rest of the available months in the report.

Appreciating your non stop support.

 

[Jeff Boyce]

One approach might be to use the Nz() function in your underlying query to
generate "0"s in place of the nulls.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[M.A.Halim]

Sorry you mean in the query grid of the crosstab or where I can apply the
NZ() function?
Thanks
M.A. Halim

--
M.A.Halim
(e-mail address removed)

One approach might be to use the Nz() function in your underlying query to
generate "0"s in place of the nulls.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/