Need report help! repeating data....

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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
--

justin said:
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
Click to expand...
 
Back
Top