Sorting Memos in a report

  • Thread starter Thread starter Richard Coutts
  • Start date Start date
R

Richard Coutts

MS Access 2000

I have a simple query that produces two colums: A column of headers in
Text format in column 1, and a column of paragraphs in Memo format in
column 2. Many of the headers are dupicates, as designed. I would
like to generate a report that groups the paragraphs with the same
header together under a single heading.

E.g., my query result looks like this:

Heading1 Paragraph1
Heading1 Paragraph2
Heading2 Paragraph3
Heading2 Paragraph4
Heading2 Paragraph5
Heading2 Paragraph6
Heading3 Paragraph7

I'd like the report to look like this:

Heading1
Paragraph1
Paragraph2
Heading2
Paragraph3
Paragraph4
Paragraph5
Paragraph6
Heading2
Paragraph7

Using the wizard I managed to get *almost* the result I want. The
only thing missing is the paragraphs are not sorting alphabetically
within each heading. The paragraphs all have a letter as their first
char. E.g., "A. Meet with..." "B. Sign contract..." etc. But, the
paragraphs are sorting randomly (which isn't what is happening with
the query -- it sorts fine).

Can someone tell me how to make the Memos, which are in the "Details"
portion of my report sort alphabetically the way the Text in the "Sec
Header" portion is? If Access can't do this, a workaround would be
appreciated.

Thanks!
Rich
 
Rich,

Whereas Access 2000 does appear to allow sorting on a Memo field, I
personally wouldn't rely on it. I would create a new calculated field
in the query like this...
SortPara: Left([Paragraph],1)
and use this as the basis of the ordering of the Paragraphs.
In either case, any sorting done in the query will not be carried
through automatically to the report. Control the sort order from the
report's Sorting & Grouping facility.

- Steve Schapel, Microsoft Access MVP
 
Back
Top