<div>
Great tips guys, and I agree, doing this in a query is fine. I just created a new query using the tblHorseAssign, and I included all the fields in that table, but as a NEWBIE I am clueless where I add this SQL statement to the new query.<br />
thx
</div>


<div>
Actually I jut figured out how to add this to a query. BUT.....How do I add it to a form. I need also a field on the form calculating the duration.<br />
thx
</div>


<div>
<div class="content wysiwyg-content">
I am using Access 2003, and I am a NEWBIE @ Access, I have 2 fields on a form, START TIME and END TIME. I want to add a field for the duration of time entered. So if the user entered START TIME 10:00 AM and END TIME 11:00 AM the field will populate 1 hour.<br />
<br />
The time duratoin will never exceed 24 hours, in fact the duration of time will never exceed 2-3 hours usually. This is for horse riding lessons, and the horses never usually get assigned to a student for more than 1-2 hours at a time.<br />
<br />
thx experts...<br />
BobR
</div>
</div>


I am using Access 2003, and I am a NEWBIE @ Access, I have 2 fields on a form, START TIME and END TIME. I want to add a field for the duration of time entered. So if the user entered START TIME 10:00 AM and END TIME 11:00 AM the field will populate 1 hour.

The time duratoin will never exceed 24 hours, in fact the duration of time will never exceed 2-3 hours usually. This is for horse riding lessons, and the horses never usually get assigned to a student for more than 1-2 hours at a time.

thx experts...
BobR

Access 2003 field to calculate time durations

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.