so the query should read something like this....
SELECT SUM(postageCost) as totalPostage
FROM tblClientDailes cd inner join tblClients C on c.clientName =
cd.clientName
WHERE cd.dailliesDate between '#date1#' and '#date2#'
AND c.acctStatus = 'A'
AND cd.clientName like '%marsh%'
GROUP BY by c.clientName
Or
SELECT SUM(postageCost) as totalPostage
FROM tblClientDailes inner join tblClients on tblClients.clientName =
tblClientDailes.clientName
WHERE tblClientDailes.dailliesDate between '#date1#' and '#date2#'
AND tblClients.acctStatus = 'A'
AND tblClientDailes.clientName like '%marsh%'
GROUP BY by tblClients.clientName
Paul
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
