Minggu, 28 Oktober 2018

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.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar