Query - Memo

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

I have a table that has a field called Memo. There are some ID Number in
the memo. When I use a query and try to figure it out how to pull ID
Number into a new column from the memo. Each notes has #123456 with few
words.

Is there a way for me to pull #123456 out of the memo into a new column in
a query?

Your feedback would be much appreciated.
Thanks,
 
Hi,

I have a table that has a field called Memo. There are some ID Number in
the memo. When I use a query and try to figure it out how to pull ID
Number into a new column from the memo. Each notes has #123456 with few
words.

Is there a way for me to pull #123456 out of the memo into a new column in
a query?

Your feedback would be much appreciated.
Thanks,

Where within the field is the ID number stored? Is it always at the
beginning, sometimes elsewhere? Is it always preceded by #? Will there
ever be two # characters? Can you count on it always having six
digits, or being followed by a blank, or any other reliable way to
delimit it?

This is an excellent example of why fields should be atomic. It's a
LOT easier to string together an ID number and some words than it is
to pull them apart!

John W. Vinson[MVP]
 
Back
Top