A
aspickwick
I am trying to write a query to categorize or bucket a memo field. I would
like to query the memo field and create 2 fields, one action and one noun
where the results would give me for the following memo field:
"replace drain valve, adjust door guide screw"
The following results
Action - replace; Noun - drain valve and
Action - adjust; Noun - door guide screw
And not:
Action - replace; Noun - Door guide screw
Action - adjust; Noun - drain valve
like to query the memo field and create 2 fields, one action and one noun
where the results would give me for the following memo field:
"replace drain valve, adjust door guide screw"
The following results
Action - replace; Noun - drain valve and
Action - adjust; Noun - door guide screw
And not:
Action - replace; Noun - Door guide screw
Action - adjust; Noun - drain valve