list all text entries from a memo field?

[cusack]

I have a "Services" table which lists particular vocational services rendered
to clients, by date. Each service is a field into which numeric values are
entered for hours of service. The table ends with a memo field for pertinent
notes. (For instance, a service is attempted on a particular day but the
client was not at home; or the client cancelled the appointment; etc.)

One of my reports must be a SUMMARY report, which must also include a
summary or synopsis of the memo field.
Is there an expression I can use in my report's design view that will list
all notes from the memo field for each client? I.e., each note listed,
separated by a comma or semi-colon?

 

[Jeff Boyce]

If you are saying that you can have multiple notes per client, why are you
(apparently) trying to "stuff" them all into a single (memo) field?

This makes your work (and Access' work) much harder!

Instead, consider a "Notes" table that stores:

tblNotes
NoteID
ClientID
TopicID
NoteDate
Note

This way, you can look up all notes belonging to a particular customer, for
a specific topic.

Regards

Jeff Boyce
Microsoft Office/Access MVP