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
Vikas Bhandari
Bookmarks