[dba-Tech] Access query

[Rocky Smolin]

Mary:

Here's a couple of links that address your problem of creating a case sensitive query:

https://www.oreilly.com/library/view/access-cookbook/0596000847/ch01s14.html

https://stackoverflow.com/questions/10046627/how-to-write-case-sensitive-query-for-ms-access

If this doesn't get you where you want to go, write back and we'll think of something else. :)

HTH


Rocky Smolin
Beach Access Software
760-683-5777
www.bchacc.com
www.e-z-mrp.com
Skype: rocky.smolin
 


-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Mary Davis
Sent: Monday, March 04, 2019 5:27 PM
To: dba-tech at databaseadvisors.com
Subject: [dba-Tech] Access query

I hope I'm posting my question in the right place.
I'm trying to use a query to match 2 tables: accounts and contacts.The account ID is case sensitive.  (it comes from SalesForce.)
I thought I found a way to add criteria to a simple query to look for case sensitive ID matches.  But I'm not able to figure out how to run this.Is this possible?  If so, can you provide me some instructions?  
This is what I came up with.
SELECT [I&P-44-4-accounts].[Account ID], [I&P-44-4-contacts].[Account ID]FROM [I&P-44-4-accounts] INNER JOIN [I&P-44-4-contacts] ON [I&P-44-4-accounts].[Account ID] = [I&P-44-4-contacts].[Account ID]WHERE (((StrComp([I&P-44-4-accounts.account id],[I&P-44-4-contacts].[account id]))=0));

thanks very much for your help.
MaryWilmington Delaware
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com