Query problem

[campbellbrian2001]

Thanks in advance for any help. I have the following query with a
conditional "count" line (counting only if vehicle loss is > $0.00. I'm
getting syntax errors that are throwing me:

SELECT qryTrucks.TagNumber, qryTrucks.Driver,
Count(IIf(qryTrucks.TotalLoss > 0),(qryTrucks.TagNumber)) AS
CountOfTrucks, Sum(qryTrucks.LossAmt) AS SumOfLossAmt,
Sum(qryTrucks.IndemCost) AS SumOfIndemCost, Sum(qryTrucks.TotalLoss) AS
SumOfTotalLoss
FROM qryTrucks
GROUP BY qryTrucks.TagNumber, qryTrucks.Driver
HAVING (((Sum(qryTrucks.LossAmt))>0) AND
((Sum(qryTrucks.TotalLoss))>0));

 

[alex]

are you attempting to do a count(if(, rather than a count(iif(.

 

[Guest]

IIf statements have 3 parts: (Evaluation, truepart, falsepart), you only have
two parts...what happens if the TotalLoss < 0? But rather then try to count
using an IIf statement, add another select statement in the count:

Count (SELECT TagNumber FROM qryTrucks WHERE TotalLoss > 0) As CountOfTrucks

 

[campbellbrian2001]

Count(IIF( there's probably a solution with better logic than
mine.

 

[Guest]

See my reply in your original post...

FYI -- As far as forum etiquette goes, if there is such a thing LOL, it is
frowned upon to enter mulitple posts, especially so close together.

 

[Guest]

Sorry, the last post was an error...

See my reply in your original post...

FYI -- As far as forum etiquette goes, if there is such a thing LOL, it is
frowned upon to enter mulitple posts, especially so close together.