I have created a table in msaccess. Fields are id_no, beginning time, end time, result. Need end time minusbeginning time. How to design this in design view. Result should be in "result" field.
Novice
Windows 7 32bit 
Access 2007
I have created a table in msaccess. Fields are id_no, beginning time, end time, result. Need end time minusbeginning time. How to design this in design view. Result should be in "result" field.
Last edited by RuralGuy; 07-27-2013 at 10:15 AM. Reason: Changed title
Administrator
Windows 7 64bit Access 2013
Easily done in a query: http://access.mvps.org/access/datetime/date0004.htm
Posting Permissions
Reply With Quote