Search results
-
L
Query-ing a query
Hi, I tried the query you suggested (or at least I think I did), and got an error. It was this. SELECT [US Brown].[Unique click], [US Platinum].[Unique click], [US GameClub].[Unique click], [US Gold].[Unique click] FROM [US Brown], [US GameClub], [US Gold], [US Platinum] GROUP BY [US... -
L
Query-ing a query
Thanks for the reply Simon- I'll give that a shot right now. -
L
Query-ing a query
I will be eternally grateful if anyone can help with this. I set up several tables in 2003 like the one listed below. (Named clicks, opens, fails etc.) Attached example I then performed a query to combine the needed data in each table and set the criteria to extract part of the mailing name... -
L
extracting characters from a text string
Thats great, thanks Paul. I'm sort of a beginner with the code so that was very helpful. :) -
L
extracting characters from a text string
Actually I did try that as well. No luck there I've posted a sample of the data I am attempting to extract. Any ideas? -
L
extracting characters from a text string
Hello, I am attempting to write a query that will extract the first two characters in a text string by specifying a certain field return only values beginning "US." Here is the sql view of the query I'm writing. SELECT Clicks.[Unique click], Failures.[Unique fail], Clicks.[Mailing Name]...