calculating time fields

  • Thread starter Thread starter Mike R.
  • Start date Start date
M

Mike R.

I have used another database program for many years but
am new to Access. I need help with expression and syntax
as to how to calculate the difference in two date/time
fields. I want to know total time, ie., endtime -
begintime.

thanx
 
You want the DateDiff function. The syntax details are in on-line help.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
I have used another database program for many years but
am new to Access. I need help with expression and syntax
as to how to calculate the difference in two date/time
fields. I want to know total time, ie., endtime -
begintime.
Click to expand...

Open the VBA editor by typing Ctrl-G (in order to bring up the proper
Help file) and search for help on "DateDiff" - it does just this. For
example,

TotTime: DateDiff("n", [begintime], [endtime])

will give a long integer number of minutes between the two times.
 
Back
Top