C
CF
I have a program that I am trying to mend until I can get
to normalize it. Anyway I have several reports that I
need the solution to this for if someone can assist I
would surely appreciate it. Here is my problem. I have a
report that has a Record Source of a Union query from a
single table. Now there are some attributes and some
attributes with details and of course when they set this
up they have check boxes to identify if is a detail.
Also, they have each attribute and detial with a unique
identifier. They also have a column named code. This is
used for each attribute. So each detail is assigned to an
attribute detailcode by the code column. Please don't ask
why I have done it many times already.
Anyway on these reports they are sorted by the code. What
they need is to have each attribute name shown with the
details underneath them. I have tried several things and
I think I am close but no cigar. Can someone assist?
Here is my solution I think, but I am not getting the
right response.
Private Sub GroupHeader2_Format(Cancel As Integer,
FormatCount As Integer)
Me.Attribute = "SELECT [tblCRTPPACResultsAttributes].
[Attribute] FROM tblCRTPPACResultsAttributes WHERE
(([tblCRTPPACResultsAttributes].[DetailsForCode])=
[Reports]![rptCommentsOnDetails]![GroupHeader1]![code)"";"
End Sub
Thanks for any help
to normalize it. Anyway I have several reports that I
need the solution to this for if someone can assist I
would surely appreciate it. Here is my problem. I have a
report that has a Record Source of a Union query from a
single table. Now there are some attributes and some
attributes with details and of course when they set this
up they have check boxes to identify if is a detail.
Also, they have each attribute and detial with a unique
identifier. They also have a column named code. This is
used for each attribute. So each detail is assigned to an
attribute detailcode by the code column. Please don't ask
why I have done it many times already.
Anyway on these reports they are sorted by the code. What
they need is to have each attribute name shown with the
details underneath them. I have tried several things and
I think I am close but no cigar. Can someone assist?
Here is my solution I think, but I am not getting the
right response.
Private Sub GroupHeader2_Format(Cancel As Integer,
FormatCount As Integer)
Me.Attribute = "SELECT [tblCRTPPACResultsAttributes].
[Attribute] FROM tblCRTPPACResultsAttributes WHERE
(([tblCRTPPACResultsAttributes].[DetailsForCode])=
[Reports]![rptCommentsOnDetails]![GroupHeader1]![code)"";"
End Sub
Thanks for any help