15 minute format

[Phailak]

Hail,

Database shows appointments for all times of day. They want to "group" them per quarter of hour so that an appointment for 9:05 is part of the 9:00 group while 10:15 is part of 10:00. The only way I have found so far is to use if statements in my query for the minutes part basically saying if it's :00 then do -15 minutes, between 01: and :15 input :00, between :16 and :30 input :15, and so forth. Is there an easier way?

Phailak

[vbNeo]

There are 4 * 15 minutes in and hour, it's rather easy to check - don't you think ? =).

Just convert the last 2 letters(after the ":") to a Long or an Integer value, and see how big it is, it's you can do it with Case or If - anyways it's easy.

Cheers!