Report_Grouping

[m stroup]

I have a report with many fields from one table. Six of the fields are memo
fields that can grow. I am trying to add a grouping to each of the memo
fields so that I can force a new page and / or keep together.

The memo fields are not showing on the field/expression dropdown. They are
valid fields and are present in the field listing.

Do I have too many other fields? Is there a limit? Can you not sort/group
on memo fields?

I tried having each of the memo fields as a subreport, but that does not
work either.

Any help you can give me is appreciated.

 

[John Spencer]

You can't (as far as I know) sort on a memo field. What you can do is use an
expression and sort on that.

Try sorting on this expression
LEFT([Name Of Memo Field],255)

As long as the first 255 characters will determine a proper sort I THINK that
might work for you.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[m stroup]

Thanks John,

This worked for me. I truly appreciate the suggestion as I was at my wit's
end.

--
Teach me to fish! Thanks for the help.
Pax, M

You can't (as far as I know) sort on a memo field. What you can do is use an
expression and sort on that.

Try sorting on this expression
LEFT([Name Of Memo Field],255)

As long as the first 255 characters will determine a proper sort I THINK that
might work for you.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

I have a report with many fields from one table. Six of the fields are memo
fields that can grow. I am trying to add a grouping to each of the memo
fields so that I can force a new page and / or keep together.

The memo fields are not showing on the field/expression dropdown. They are
valid fields and are present in the field listing.

Do I have too many other fields? Is there a limit? Can you not sort/group
on memo fields?

I tried having each of the memo fields as a subreport, but that does not
work either.

Any help you can give me is appreciated.

.