Re: [MS_AccessPros] query when there are record that differ for capital letter

 

you're welcome, Valentino  ~ happy to help

On 10/28/2018 1:30 PM, Valentino Avvisati valentino.avvisati@gmail.com [MS_Access_Professionals] wrote:

Crystal,

thank you very much

It works perfectly!

 

Valentino

Il giorno dom 28 ott 2018 alle ore 07:51 crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> ha scritto:

 

the full SQL would be:

SELECT aptbstr01.code, aptbstr02.code

FROM aptbstr01, aptbstr02
WHERE StrComp(aptbstr01.code, aptbstr02.code, 0) = 0
 
~crystal

On 10/27/2018 5:30 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

you're welcome,

instead of linking with a join line, you could match records using criteria. For example:

WHERE StrComp(aptbstr01.code, aptbstr02.code, 0) = 0

respectfully,
crystal

Unicode Character Map -- free tool in Access
http://msaccessgurus.com/tool/UnicodeCharMap.htm

On 10/27/2018 1:55 PM, Valentino Avvisati valentino.avvisati@gmail.com [MS_Access_Professionals] wrote:

Thank you Crystal, 

my problema is that I need to link some table using this field and I have non clear how I can do the inner join between the two tables, it is possible have an example how have the query below but case sensitive? 

SELECT aptbstr01.code, aptbstr02.code

FROM aptbstr01 INNER JOIN aptbstr02 ON aptbstr01.code = aptbstr02.code

Valentino 

Il giorno 27 ott 2018, alle ore 16:44, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> ha scritto:

SELECT aptbstr01.code, aptbstr02.code

FROM aptbstr01 INNER JOIN aptbstr02 ON aptbstr01.code = aptbstr02.code;

 

I get a result of 4 record because for

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (8)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___