Report Grouping

J

Jill76

Can I group fields in a report that have memo data types? I’ve tried
unsuccessfully.

My objective is to create a report based on a query that includes the fields
indicated below:

Table One Fields: 1) Investor Name
Table Two Fields: 1) General Information, 2) GI Source, and 3) GI Date
Table Three Fields: 1) Activity, 2) Act Source, and 3) Act Date

The General Information and Activity fields are memo fields. We are placing
article excerpts in these fields, most excerpts are lengthier than 255
characters, which is why we must use memo, not text, data types.

We wish to design our report to reflect as follows:

Investor Name (ABC Company) to populate first

Followed by a grouping of all Gen Info records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

Followed by a grouping of all Activity records linked to ABC Company, sorted
in date order (i.e. article excerpt #1, it’s source, it’s date; article
excerpt #2, it’s source, it’s date; etc.)

I tried to create the above, but the report was full of empty boxes and
duplicate data. I think my problems stem from a Grouping issue. However,
the fields I want to group by are not grouping options since they have memo
data types. I know that Access is capable of accomplishing my intent – it
has achieved greater things. I just don’t know where to start. I’m
desperate for assistance, pleeease help me. Thank you.
 
M

Marshall Barton

Jill76 said:
Can I group fields in a report that have memo data types? I’ve tried
unsuccessfully.

[snip the details]

We'll keep the discussion in the original thread where we
are far beyond the point of this question.

I'm just posting this to save others that might not be aware
of the other thread the effort of trying to catch up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top