[dba-Tech] Access query

Rocky Smolin rockysmolin at bchacc.com
Tue Mar 5 10:28:01 CST 2019


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



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


Rocky Smolin
Beach Access Software
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
Website: http://www.databaseadvisors.com

More information about the dba-Tech mailing list