Need report help! repeating data....

[Duane Hookom]

Are you sure you want to group on ProjectAccomplishmentsTbl.Description? If
it is a memo field, I can't imagine why you would even try to do that.

Either PIVOT a description field or place the numeric ActivityID values in
the Column Headings property.

 

[Guest]

I don't want to group on ProjectAccomplishmentsTbl.Description. What I want
to do is display the discription field with the totals. Some of the
accomplishments have a discription that goes with them. For example, the
accomplishment Plans&Assessment, is more than just a number, there is a
discription that goes with it saying, "distributed x amount of articles" or
something like that. So I need that to show up too.

I put the numeric activityID values into teh column headings property and
now things look better. I assume I can just change the label for those on the
report to read the actual name of the activity and not just the ID number?

What do you mean by "PIVOT a description field"?

Thanks.

-Justin

 

[Duane Hookom]

Q) What do you mean by "PIVOT a description field"?
A) Notice in your SQL view of the crosstab, there is a PIVOT... statement.
If you don't want to use the ID field, you would change this to the field
that would display the "description field".


--
Duane Hookom
MS Access MVP
--

I don't want to group on ProjectAccomplishmentsTbl.Description. What I want
to do is display the discription field with the totals. Some of the
accomplishments have a discription that goes with them. For example, the
accomplishment Plans&Assessment, is more than just a number, there is a
discription that goes with it saying, "distributed x amount of articles"
or
something like that. So I need that to show up too.

I put the numeric activityID values into teh column headings property and
now things look better. I assume I can just change the label for those on
the
report to read the actual name of the activity and not just the ID number?

What do you mean by "PIVOT a description field"?

Thanks.

-Justin