Search results

  1. L

    anyone see where i messed up this query?

    SELECT [US Platinum].[Mailing Date], Sum([US Platinum].[Unique click], [US Brown.Unique Click], [US Gold.Unique Click] [US GameClub.Unique Click]) AS sum[SumOfUnique click1] FROM [US Brown], [US GameClub], [US Gold], [US Platinum] GROUP BY [US Platinum].[Mailing Date]; This is a query written...
  2. 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...
  3. 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]...
Back
Top Bottom