Solved

Short time auto-generated

Posted on 2013-06-07
2
363 Views
Last Modified: 2013-06-07
I have an application people are using the 'scan into' work.

I want to store hours and minutes only, but am using "default value" of time$(); which returns long value (hh:mm:ss).  The reason it is important to not record seconds is that I want to ensure that a person isn't able to scan in twice (accidentally), so time is part of the key field.

how can I store a default value of hh:mm only?
0
Comment
Question by:TIgerV
2 Comments
 
LVL 20

Accepted Solution

by:
clarkscott earned 500 total points
ID: 39229838
= format(YourValue, "hh:nn")

Scott C
0
 

Author Closing Comment

by:TIgerV
ID: 39229855
Thank You!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question