thanks for the help....
this one may be slightly easier.
The area id needs to loop between 1 and 22
SELECT AreaNames.[Area ID], [IMP - SAM Branch Activity 2005].Week, Sum([IMP - SAM Branch Activity 2005].[Mortgage Booked Appts]) AS [SumOfMortgage Booked Appts], Sum(Targets___ALL.MWBookedAppts) AS SumOfMWBookedAppts
FROM AreaNames INNER JOIN (Targets___ALL INNER JOIN ([IMP - SAM Branch Activity 2005] INNER JOIN CoreBranchLookup ON [IMP - SAM Branch Activity 2005].[Branch ID] = CoreBranchLookup.[Child Branch ID]) ON (Targets___ALL.Year = [IMP - SAM Branch Activity 2005].Year) AND (Targets___ALL.Week = [IMP - SAM Branch Activity 2005].Week) AND (Targets___ALL.Branch = [IMP - SAM Branch Activity 2005].[Branch ID])) ON AreaNames.[Area ID] = CoreBranchLookup.[Area ID]
GROUP BY AreaNames.[Area ID], [IMP - SAM Branch Activity 2005].Week;
With this one the branch needs to loop through the letters of the alphabet in the like statement
SELECT tbl2004.branch, tbl2004.status, tbl2004.clientName, tbl2004.dateCreated, tbl2004.originator, tbl2004.originatorID, tbl2004.postcode, tbl2004.phoneHome, tbl2004.phoneWork, tbl2004.phoneMobile, tbl2004.homeOwner, tbl2004.loanValue, tbl2004.term, tbl2004.lender, tbl2004.ppi, tbl2004.offerDate
FROM tbl2004 INNER JOIN tblBranches ON tbl2004.branch = tblBranches.branchOriginal
WHERE (((tbl2004.branch)="Contact Centre") AND ((tbl2004.dateCreated)>#11/1/04#) AND ((tbl2004.postcode) Like "a*"))
ORDER BY tbl2004.branch, tbl2004.status, tbl2004.dateCreated;
Cheers
Mike