Unanswered: Count on Multiple Text Fields in Table
In a Simple Query,
I want to be able to Count the Text data in several Fields of a single Table. Ex: Shipping Field & Via & Pounds. I want a total of all "Rush" text in Shipping Field, "Truck" text in Via, and just a total # of pounds in Pounds (numeric)...
I am using Count in each one and a ="Rush", ="Truck"... etc on the criteria lines but keep getting a Data Type Mismatch error
What is the easy way to do this??? What am I doing wrong??
SELECT Count(Shipped.POUNDS) AS CountOfPOUNDS, Count(Shipped.[SHIP SPECIAL]) AS [CountOfSHIP SPECIAL], Count(Shipped.TRANSPORT) AS CountOfTRANSPORT
HAVING (((Count(Shipped.[SHIP SPECIAL]))="RUSH") AND ((Count(Shipped.TRANSPORT))="TRUCK"));