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