[AccessD] Question on hours again

You are not being a pest at all. Your questions are exactly why
AccessD and DatabaseAdvisors was created. All of us were new to this
at one point.

The Format string would do in the control source for a text box
control in the report footers. You would need the previously described
Minutes:datediff("h",[TimeIn],[TimeOut]) in the query for it to work
in the report though. And you would need an equals sign in front of
that first format.

If you can get A J's VBA code based solution going that might be a
better way to do it of course. But there is almost always more than
one way to bet it to work too.

Good luck with it.

I just thought of another possible solution too. If you created
another field in your data file that was the number of minutes and
then populated that either at data entry time or via an update query,
then you could use that field to do your totalling on. You would still
have the issue of displaying hours and minutes on your report totals
though.  Wouldn't be considered good database design either since you
would be storing a field that you could calculate from other stored
fields. But some times we have to do things that are not exactly
perfect from a database design point of view too.

GK

On 12/5/06, DorisH3 at aol.com <DorisH3 at aol.com> wrote:
> Hi Gary,
>
> Thanks for your help I really appreciate it....because I am a novice at  this
> can you tell me if I put format((sum(Minutes)\60),'0000') & *:" &
> format(sum(Minutes) mod 60,"00") in a control on the report or do I put in the  query
> that does the subtracting of the TimeOut and TimeIn?  Sorry that I'm  being such
> a pest.
>
> Doris
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com