Locate a value in a memo field that begins with 618DI

[jlig via AccessMonster.com]

I have a Table which contains 2 fields. One is acct (text type) & the other
is called notes. (It's type is Memo.)

I need a listing of all acct's which have a 618DI in their memo field. (Thats
a capitol i )

The query should list the acct number followed by the 618DI value.
There will always be 5 numbers following the 618DI.

Here's what the output should look like:
1001 618DI12345
1002 618DI10007
2025 618DI52014
etc...

I have used Mid([notes],InStr([notes],"618DI ")+7,10) in my query grid but
it only gives me the values before the 618DI.

Thanks, for your help,
jlig

 

[Rick B]

Just use...

Like "*618DI*"

 

[jlig via AccessMonster.com]

Rick, Thanks for jogging my memory.

I used:
SELECT tblCust.acct, Mid([notes],InStr([notes],"618DI")+0) AS FICTNx
FROM tblCust
WHERE (((tblCust.notes) Like "*618DI*"));

Thanks,
jlig

Just use...

Like "*618DI*"

I have a Table which contains 2 fields. One is acct (text type) & the other
is called notes. (It's type is Memo.)

[quoted text clipped - 16 lines]

Thanks, for your help,
jlig