By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,799 Members | 1,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,799 IT Pros & Developers. It's quick & easy.

MS Access Memo Fields

P: n/a
Hi

I am a novice at Access (2002) and I need some help. I want to use a
query to interrogate a memo field which contains the body of an email
but despite help with the syntax etc. I can not get it to return any
records.

Can anyone tell me if there are limitations using queries on Memo
fields? For example, do they just look at the first 255 characters,
all the field contents or just not work at all

The query I am running is:

SELECT Emails.*
FROM Emails
WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
ucase(Emails.MessageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];

I was also unsure whether the Like function is case sensitive

Thanks

Jun 12 '07 #1
Share this Question
Share on Google+
4 Replies

P: n/a
<ph***********@gartmore.comwrote in message
news:11*********************@x35g2000prf.googlegro ups.com...
Hi

I am a novice at Access (2002) and I need some help. I want to use a
query to interrogate a memo field which contains the body of an email
but despite help with the syntax etc. I can not get it to return any
records.

Can anyone tell me if there are limitations using queries on Memo
fields? For example, do they just look at the first 255 characters,
all the field contents or just not work at all

The query I am running is:

SELECT Emails.*
FROM Emails
WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
ucase(Emails.MessageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];

I was also unsure whether the Like function is case sensitive

Thanks
I'm not sure if this will solve your problem but you could start by using
double-quotes instead of singles and asterisks instead of percent.

Keith.
www.keithwilby.com

Jun 12 '07 #2

P: n/a
On Jun 12, 2:45 pm, "Keith Wilby" <h...@there.comwrote:
<philip.spi...@gartmore.comwrote in message

news:11*********************@x35g2000prf.googlegro ups.com...


Hi
I am a novice at Access (2002) and I need some help. I want to use a
query to interrogate a memo field which contains the body of an email
but despite help with the syntax etc. I can not get it to return any
records.
Can anyone tell me if there are limitations using queries on Memo
fields? For example, do they just look at the first 255 characters,
all the field contents or just not work at all
The query I am running is:
SELECT Emails.*
FROM Emails
WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
ucase(Emails.MessageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];
I was also unsure whether the Like function is case sensitive
Thanks

I'm not sure if this will solve your problem but you could start by using
double-quotes instead of singles and asterisks instead of percent.

Keith.www.keithwilby.com- Hide quoted text -

- Show quoted text -
Thanks Keith

Don't know why but it seems to have worked!!! :-)

Jun 12 '07 #3

P: n/a
"Phil" <ph***********@gartmore.comwrote in message
news:11*********************@r19g2000prf.googlegro ups.com...
>
Thanks Keith

Don't know why but it seems to have worked!!! :-)
Your original query might have worked on an Oracle table but " and * are
what Access expects instead of ' and %.

Jun 12 '07 #4

P: n/a
ph***********@gartmore.com wrote:
SELECT Emails.*
FROM Emails
WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
ucase(Emails.MessageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];
The wildcard character in MS Jet is *, not the % you're used to seeing
in many other database systems. I personally prefer to use double
quotes with Access/Jet as well.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Jun 12 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.