Modify length of Time to HH:MM in an expression based on Dlookup results

[Bkper087]

I want to combine two times into one text box for visual sake on a report. When I combine it is shows the time in HH:MM:SS AM/PM format. The source is set to medium format which is HH:MM AM/PM. If I place the field onto the report directly, it shows correctly (as HH:MM). However, when I try to combine two fields in an expression using the Dlookup function i.e.: Dlookup (Time, Table, Criteria)&"-"&Dlookup (Time, Table, Criteria), the result shows the date in long form. How do I get it to show like this: MM:HH AM - MM:HH PM

[June7]

Try Format() function:

Format(Dlookup (Time, Table, Criteria), "Medium Time") & " - " & Format(Dlookup (Time, Table, Criteria), "Medium Time")