formating combo box to display time

[Daniel.Philbrick]

I have a form that uses a SELECT DISTINCTROW statement to pull in a
time value from a table that stores a "start time" and an "end time">
The problem is when the combo box displays the values from this table
is shows seconds. All I need is HH:MM. Is there an easy way to format
my SQL statement to do this? I have attached my statement:


SELECT DISTINCTROW classtime.ID, [starttime] & "-" & [endtime] AS
classtime FROM classtime;

Right now it displays a value in the box like:

04:00:00PM-06:30:00PM
but I would like
04:00PM-06:30PM

Thanks in advance!
DKP

 

[Brendan Reynolds]

Format$([starttime],"hh:nn") & "-" & Format$([endtime],"hh:nn")

 

[Daniel.Philbrick]

Thanks Brendan! Worked like a charm. I also added ampm after the hh:nn
which forced it to show AM PM format.Thanks again!