[dba-Tech] Access query
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. :)
Beach Access Software
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.
dba-Tech mailing list
dba-Tech at databaseadvisors.com
More information about the dba-Tech