creating LIKE using field from DB

[1DMF]

Hi,

I have a query that works in SQL

SELECT Subject,Notes,CallId FROM Calls WHERE Notes NOT LIKE Subject + '%'

Only when I try this in access it wont run

SELECT Subject,Notes,CallId FROM Calls WHERE Notes NOT LIKE (Subject + '*')

What's the correct syntax for that SQL query in access ?

Thanks,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta

 

[1DMF]

must have made a typo as it now works, sorry to have bothered you.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta

 

[dhookom]

1DMF,
You have asked enough questions here that you should understand that "wont run" is never adequate.

It's good to hear that it is now working but please practice better posting.

Duane
Hook'D on Access
MS Access MVP