hi
i have a crosstab query, that displays information dynamically, but i have set it to static, as the data fields never change, but what i have a problem with, is when there is no data in a field, the field displays but i need to carry out a calculation based on the data, so is there any way i can assign a default value to the query?
here is my query
i have a crosstab query, that displays information dynamically, but i have set it to static, as the data fields never change, but what i have a problem with, is when there is no data in a field, the field displays but i need to carry out a calculation based on the data, so is there any way i can assign a default value to the query?
here is my query
Code:
TRANSFORM Sum(MainQuery_ENG_FP_RemainingVehicleWashes.totalSideWashes) AS SumOftotal
SELECT "Remaining" AS [Week No]
FROM MainQuery_ENG_FP_RemainingVehicleWashes
GROUP BY "Remaining"
PIVOT MainQuery_ENG_FP_RemainingVehicleWashes.Expr1 In ("Week 1","Week 2","Week 3","Week 4");