sum an expression in a query

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
update cross tab query in a report 7
Sum of Time 1
Report and subreport pulling from same query. 2
sum error 2
Expression error 7
Total is off by a couple of cents 4
Access Expression Builder 0

Top