Access: Minute Function
In Access, the Minute function returns the minute of the hour (a number from 0 to 59) given a time value.
The syntax for the Minute function is:
Minute ( time_value )
time_value is a valid time.
For example:
Minute (#10:42:58 PM#) would return 42 Minute (#10:13:58 AM#) would return 13 Minute (#22/11/2003 10:00:58 PM#) would return 0
VBA Code
The Minute function can be used in VBA code. For example:
Dim LMinute As Integer
LMinute = Minute (#10:13:58 AM#)
In this example, the variable called LMinute would now contain the value of 13.
SQL/Queries
You can also use the Minute function in a query.
