Query part of string

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Hello, I need to pull part of a field in a query. The
field could have several notes, I only need to see then
notes beginning with "Customer" on. That is the starting
point I need to see without pulling anything that comes
before that word. Is this possible?

Thanks!
 
Hi Mary

Your query should look something like this:

Like "Customer" & "*"

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Hello, I need to pull part of a field in a query. The
field could have several notes, I only need to see then
notes beginning with "Customer" on. That is the starting
point I need to see without pulling anything that comes
before that word. Is this possible?

Thanks!
Click to expand...

You're paying the penalty for improper table design! Fields should be
"atomic", having only one meaning. It's much easier to concatenate
multiple values into a paragraph than vice versa.

But if you have a memo field named [Notes] and you want to see
whatever comes after the first instance of the word Customer, you can
use

NewName: Mid([Notes], InStr([Notes], "Customer") + 9)


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks for the help. I am paying the price - but I didn't
design the database so I'm trying to find ways to work
with what I've got.
Thanks!
-----Original Message-----
Hello, I need to pull part of a field in a query. The
field could have several notes, I only need to see then
notes beginning with "Customer" on. That is the starting
point I need to see without pulling anything that comes
before that word. Is this possible?

Thanks!
Click to expand...

You're paying the penalty for improper table design! Fields should be
"atomic", having only one meaning. It's much easier to concatenate
multiple values into a paragraph than vice versa.

But if you have a memo field named [Notes] and you want to see
whatever comes after the first instance of the word Customer, you can
use

NewName: Mid([Notes], InStr([Notes], "Customer") + 9)


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.
Click to expand...
 
Back
Top