Using "Minutes" in a IIF.....

[NewTeki]

Does anyone know of a way to compare the minutes of a time field to a number. For example: I need to compare the minutes of a clocked in Time, if it is > 53 zero out minutes and add 1 to the Hour. If it is between 46 and 53, make it 45. etc. Maybe something like this is too much for Access. Any guidance would be appreciated.

Jim

 

[Frink]

Hallo,

Have you looked at the Minute function in Access Help?

You could write a function that performs the calculation you require using the Minute and DateAdd functions,

- Frink

 

[NewTeki]

Nothing came up in Help when typing in minute.

 

[Frink]

Hallo,

Oh. I'm using Access '97 and it says this:

-----------------------------------------------------------
Minute Function
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour.

Syntax

Minute(time)

The required time argument is any Variant, numeric expression, string expression, or any combination, that can represent a time. If time contains Null, Null is returned.

-----------------------------------------------------------
Minute Function Example
This example uses the Minute function to obtain the minute of the hour from a specified time. In the development environment, the time literal is displayed in short time format using the locale settings of your code.

Dim MyTime, MyMinute
MyTime = #4:35:17 PM# ' Assign a time.
MyMinute = Minute(MyTime) ' MyMinute contains 35.
-----------------------------------------------------------



Hope that helps, I suppose you could also use Val(Format$(Now(),"n&quot).


- Frink