Hey Teddy, thanks, you may be right, but I made more of a mess with the iif statements!
Here is the SQL:
SELECT Count(Shipped.POUNDS) AS CountOfPOUNDS, Count(Shipped.[SHIP SPECIAL]) AS [CountOfSHIP SPECIAL], Count(Shipped.TRANSPORT) AS CountOfTRANSPORT
HAVING ((Shipped.[SHIP SPECIAL]="Pending") AND (Shipped.TRANSPORT="Information"));
That makes sense. Count returns the number of records for a given field. Take a look at your "HAVING" clause. You are counting the number of records which have [SHIP SPECIAL] = "Pending" AS WELL AS Shipped.TRANSPORT = "Information". you are getting the number of records that match both criteria, naturally the number of records returned is going to be the same for each field.
Try something more like this:
SELECT SUM(shipped.pounds), SUM(iif(shipped.[ship special] = "pending", 1, 0)) AS [CountOfSHIP SPECIAL], SUM(iif(shipped.transport = "Information", 1, 0)) AS CountofTRANSPORT
We're talking three seperately aggregated values here, you have to present it as such.