HELP: Extracting from a Memo Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 09 May 2005 13:17 GMT

Access 2000

My database project has a field that contains multiple offenses per person,
and I have set up a MEMO field for the Offense(s) category.
Example:

PERSON OFFENSE(s)
SMITH 1. XXX
2. YYY
3. ZZZ

Is there a way to extract offense "XXX" from the MEMO field, or should I
have it structured to where I have a field that has Primary Offense and a
MEMO field for supplementary offenses?

Reply to this Message

Duane Hookom - 09 May 2005 15:14 GMT

I would not store multiple values like this in a field. Consider normalizing
your table structure by creating a second table that contains one record per
person per offense. You could add a field to identify which offense is the
primary offense.

Signature

Duane Hookom
MS Access MVP
--

> Access 2000
>
[quoted text clipped - 11 lines]
> have it structured to where I have a field that has Primary Offense and a
> MEMO field for supplementary offenses?

Reply to this Message