writing excel VBA Query for fetching data from Access
Please dont remove this thread...its an excel question only...
I am wrting the following query to get some data into excel from Access
qur = "SELECT [Temp01.campaign] & [Temp01.AdGroup] & [Temp01.Keyword] AS Expr1 FROM temp01 where expr1 not in (SELECT [Campaigns.campaign] & [Campaigns.AdGroup] & [Campaigns.Keyword] as expr2 from campaigns where expr2<>expr1)"
I am checking the combination of campaign, adGroup, and Keyword in two tables and finding the unique values and then entering them in the excel...
The above query doesnt seem to be working....any help would be appreciated
Try with this sql:
Dammnnnn....too good!!! I am really really impressed and believe me Antonio....
You are the Best
I'm sorry to answer so late to your question.
If you have a table named 'TAB01' with the first three columns named 'C01', 'C02', 'C03', and the fourth named 'CTR' you can use this query:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1