HELP: Extracting from a Memo Field

From: Tim <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 9 May 2005 05:19:01 -0700

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?
.

Follow-Ups:
- Re: Extracting from a Memo Field
  - From: Duane Hookom

Prev by Date: RE: Setting up a date query
Next by Date: Case Sensitivity In Queries Linked to Oracle Database
Previous by thread: How can I sort colums
Next by thread: Re: Extracting from a Memo Field
Index(es):
- Date
- Thread