HELP: Extracting from a Memo Field

[Guest]

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?

 

[Duane Hookom]

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.