Totals not available

[Hubler]

I have a query that grabs the hours from a timecard of a specified employee from a specified date. There can be several cost codes or projects associated with that employee for that day and would like a sum of these hours. In the query I have the following expression:



WEST: IIf([Date worked]=[Forms]![TS Review]![WeekEnding],[Timecard Details]![ST],"")

The total is set to Group by. If I change it to Sum, It gives a message as being too complex. If I change it to expression it gives me a messaage "You tried to execute a query that does not include the specified expression WEST: IIf([Date worked]=[Forms]![TS Review]![WeekEnding],[Timecard Details]![ST],"") as part of an aggregate function"

In the datasheet view when I use the toatls count is the only option available.

Can someone please give me guidance on how to get the totals. Or if I am comming at this in completely the wrong angle. Tried doing with crosstabs but ran into snafus with multiple values and columns. Attached is a screenshot of what I am trying to accomplish.

[boblarson]

If ST is a numeric value, you can't assign "" to it. Use 0 instead.

[Hubler]

Thanks Bob, I substituted the "" with "null" and that allowed me to get my totals.