Partition in a crosstab query

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Someone a few months ago explained to me how to use a partition
command in a cross-tab query to create 3 distinct categories based on
a number value. It's been working great, but in some cases, there is
no data for the categories and in the report, an error message pops up
that [1:12] is not a valid field name. (That's correct because no
values are between 1 and 12.) Is there a way to populate 1:12 with a
zero in the crosstab, so that the message will not appear?

Thanks

Jeff
 
Jeff said:
Someone a few months ago explained to me how to use a partition
command in a cross-tab query to create 3 distinct categories based on
a number value. It's been working great, but in some cases, there is
no data for the categories and in the report, an error message pops up
that [1:12] is not a valid field name. (That's correct because no
values are between 1 and 12.) Is there a way to populate 1:12 with a
zero in the crosstab, so that the message will not appear?
Click to expand...


Not at all elegant, but if you can determine the exact
headings from the Partition function, enter them into the
query's Headings property.
 
Back
Top