I have created an expresssion in a query that converts hours and minutes to
decimal times. I would like to add the total decimal times for a month in my
report but I keep getting a message that the expression is too complex. I
have tried using the "sum" operator in the query but then I get the same
message. Anyone know how I can add the column in the report? Putting sum in
the totals column in the Query doesn't work either.
Duane Hookom - 04 Oct 2004 05:05 GMT
Maybe you could share the "expression".

Signature
Duane Hookom
MS Access MVP
> I have created an expresssion in a query that converts hours and minutes to
> decimal times. I would like to add the total decimal times for a month in my
> report but I keep getting a message that the expression is too complex. I
> have tried using the "sum" operator in the query but then I get the same
> message. Anyone know how I can add the column in the report? Putting sum in
> the totals column in the Query doesn't work either.