MS Access Memo Fields

[philip.spinks]

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.Me ssageTxt) Like '%BUY%' Or
ucase(Emails.Me ssageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];

I was also unsure whether the Like function is case sensitive

Thanks

[Keith Wilby]

<ph***********@ gartmore.comwro te in message
news:11******** *************@x 35g2000prf.goog legroups.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.Me ssageTxt) Like '%BUY%' Or
ucase(Emails.Me ssageTxt) 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

[Phil]

On Jun 12, 2:45 pm, "Keith Wilby" <[e-mail] wrote:

<philip.spi...@ gartmore.comwro te in message

news:11******** *************@x 35g2000prf.goog legroups.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.Me ssageTxt) Like '%BUY%' Or
ucase(Emails.Me ssageTxt) 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!!! :-)

[Keith Wilby]

"Phil" <ph***********@ gartmore.comwro te in message
news:11******** *************@r 19g2000prf.goog legroups.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 %.

[Tim Marshall]

ph***********@g artmore.com wrote:

SELECT Emails.*
FROM Emails
WHERE ucase(Emails.Me ssageTxt) Like '%BUY%' Or
ucase(Emails.Me ssageTxt) 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