Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT DISTINCTROW tbl_Client_Data.Client, [199911].Jobname, Sum([199911].Impressions) AS [Print Impressions]
FROM 199911, tbl_Client_Data
WHERE (((tbl_Client_Data.Client) Like "*mellon*") AND (([199911].Jobname) Like "ALP*" Or ([199911].Jobname) Like "BET*"))
GROUP BY tbl_Client_Data.Client, [199911].Jobname;
SELECT DISTINCTROW tbl_Client_Data.Client, Left([199911].Jobname,3), Sum([199911].Impressions) AS [Print Impressions]
FROM 199911, tbl_Client_Data
WHERE (((tbl_Client_Data.Client) Like "*mellon*") AND (([199911].Jobname) Like "ALP*" Or ([199911].Jobname) Like "BET*"))
GROUP BY tbl_Client_Data.Client, Left([199911].Jobname,3);