View Single Post
  #5  
Old August 29th, 2008, 09:12 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Convert time to number

On Fri, 29 Aug 2008 10:51:00 -0700, Golfinray
wrote:

Use the Datediff command in your query criteria. Datediff("d",[time in],[time
out])
The "d" will give you the answer in days,. If you want it in minutes, I
think it is either m or mm.


Actually "m" is Months; "n" is miNutes.
--

John W. Vinson [MVP]