[AccessD] Question on hours

Take a look at the DateDiff function Doris. Try changing your hours calc to

DateDiff("h",TimeIn,Timeout)

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> DorisH3 at aol.com
> Sent: 05 December 2006 04:01
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Question on hours
> 
> 
> I have a table that maintains the Volunteer Number, Time In, 
> Time Out, Date  
> Worked.  I have put together a report using a query that 
> shows the  volunteers 
> name, volunteer number, date worked, time in, time out.  On 
> the  report I 
> show all of the fields that are contained in the query along 
> with a  calculation 
> TimeOut - TimeIn which I named Hours.  My report looks like  this
>  
> Name               Vol#     Date              TimeIn        
> TimeOut        
> Hours
> Alice White     1099
>                                  10/1/06         4:00  PM     
> 7:00  PM        
>   3
>                                   10/5/06         4:00  PM    
>  7:00  PM       
>    3
>  
> 10/7/06         4:00  PM     7:00  PM          3
>                                   10/10/06       4:00  PM     
> 7:00  PM        
>   3
>  
> In the group footer I did a calculation as follows 
> =Sum([Hours])  and  in the 
> report footer I did the same.
>  
> It appears that anything under 24 hours calculates OK, 
> anything over 24  
> hours is incorrect....can anyone help me...I am a novice at 
> this so I apologize  
> ahead of time.
>  
> Doris
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>