Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query memo field to only show

Status
Not open for further replies.

coolkake

Technical User
Apr 5, 2002
51
CA
Hey all

I've got to figure out a way to query a memo field to only show me the numbers after CLIENTELE CALL in the memo field

It would look like this in the field

CLIENTELE CALL 12345

When I try a query looking for CLIENTELE CALL it returns everything in the memo field and I can't figure out a way to only show what I'm looking for :(

Thanks for your help in advance :)

Ken
 
That has got it guys!!!!
Thanks a lot :)
This is great because I've got an example now of how to do this and there's a whole bunch more things I can do now :)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top