<div>
Both solutions work but I like the first one better.<br />
<br />
Thanks
</div>


Both solutions work but I like the first one better.

Thanks

<div>
<div class="content wysiwyg-content">
I have a textbox called txtTurn with, for example, 5:12 where 5 represents hours and 12 represents minutes<br />
<br />
I need code to extract the minutes portion of 12 to put it in a textbox called txtMin. I have no idea how to do that. If it matters it could show as 05:12 or just 5:12 depending on the user.<br />
<br />
Thanks<br />
<br />
PBLack
</div>
</div>


I have a textbox called txtTurn with, for example, 5:12 where 5 represents hours and 12 represents minutes

I need code to extract the minutes portion of 12 to put it in a textbox called txtMin. I have no idea how to do that. If it matters it could show as 05:12 or just 5:12 depending on the user.

Thanks

PBLack

How do I extract minutes from a time count?

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.