By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,435 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,435 IT Pros & Developers. It's quick & easy.

Problem finding sum of DateDiff Field on report

P: n/a
I have query which shows when employees clock in (long time) and clock
out(long time). To find the total hours worked in hours and minutes I
have another field on my query with the following:

Total: DateDiff("n",[TimeIN],[TimeOUT])\60 &
Format(DateDiff("n",[TimeIN],[TimeOUT]) Mod 60,"\:00")

This works great. I then made a report simply showing all the info from
the query. My problem now is trying to find the total of the total
fields. I tried putting "=Sum([Total])" in an unbound field on the
report but it says that it is too complicated.

What should I do to find this total on the report?

Shawn Yates

Jul 3 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
you should leave the totals as numbers (without format() function,
which turns the value into a string. then you can total on it. Either
that or include another copy in a hidden control, then total on that.

Jul 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.