J
JoyAA
Hello,
I am following "How to Concatenate a List of Items from a Many-Side Table"
article (Article ID : 210163) to get data grouped as I need in my report. In
that example, the sort order is based on the category name, the product name
is the concatenated field. In my database, I have other fields related to the
category which are displayed on the report. Also, I have a form which allows
the user to specify the order by for the data displayed. I use the report's
Open event to change the ControlSource property of the sorting and grouping
entry.
This all works fine when I order by the category name or any other field
until I need to do is sort by the concatenated field, product name. When I
try to order by that field, the concatenated field is "ungrouped."
What I need is to have the product name grouped together (by category name)
and then sorted by the concatenated product name.
Please advise.
I am following "How to Concatenate a List of Items from a Many-Side Table"
article (Article ID : 210163) to get data grouped as I need in my report. In
that example, the sort order is based on the category name, the product name
is the concatenated field. In my database, I have other fields related to the
category which are displayed on the report. Also, I have a form which allows
the user to specify the order by for the data displayed. I use the report's
Open event to change the ControlSource property of the sorting and grouping
entry.
This all works fine when I order by the category name or any other field
until I need to do is sort by the concatenated field, product name. When I
try to order by that field, the concatenated field is "ungrouped."
What I need is to have the product name grouped together (by category name)
and then sorted by the concatenated product name.
Please advise.