M
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.
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.