The joys of doing corporate taxes as a computer programmer:
SELECT DISTINCT [SR Commission].[Check No],
(SELECT SUM([Amount])
FROM [SR Commission] AS SRCom
WHERE SRCom.[Check No] = [SR Commission].[Check No])
AS Total, [Sales Reps].[Sales Rep], [Sales Reps].Name
FROM [SR Commission] INNER JOIN
[Sales Reps] ON
[SR Commission].[Sales Rep] = [Sales Reps].SalesRepID
WHERE ([SR Commission].ChkDate > ‘2006-01-01 00:00:00′) AND
([SR Commission].Paid = 1) AND
([SR Commission].ChkDate < '2006-12-31 00:00:00') AND
([Sales Reps].[Sales Rep] <> ‘MAST’)
Leave a Comment