shrink dates for report

[Guest]

I hope someone can help, this seems such a simple thing to do, on a report i
have two fields StartTime and EndTime

i have created one field that combines the two using

Time: [tblSchedule].[StartTime] & " - " & [tblschedule].[EndTime]

the only problem i have is that the time displays as

09:00.00 - 09:30.00
10:00.00 - 10:30.00

and i would like them to display as:

09:00 - 09:30
10:00 - 10:30

i have tried setting the properties to Short Time, and the individual fields
to short time but it has no effect, it must be a simple answer but i am not
seeing

thanks for your help in advancer

Phil

 

[John Vinson]

I hope someone can help, this seems such a simple thing to do, on a report i
have two fields StartTime and EndTime

i have created one field that combines the two using

Time: [tblSchedule].[StartTime] & " - " & [tblschedule].[EndTime]

the only problem i have is that the time displays as

09:00.00 - 09:30.00
10:00.00 - 10:30.00

and i would like them to display as:

09:00 - 09:30
10:00 - 10:30

Try:

Time: Format([tblSchedule].[StartTime], "hh:nn") & " - " &
Format([tblSchedule].[EndTime], "hh:nn")

You're not limited to the named formats, there are lots of options!

John W. Vinson[MVP]

 

[Guest]

Thanks that worked great, i knew it would be something simple, what is they
say they are only easy when you know the answers

thanks again

Phil

I hope someone can help, this seems such a simple thing to do, on a report i
have two fields StartTime and EndTime

i have created one field that combines the two using

Time: [tblSchedule].[StartTime] & " - " & [tblschedule].[EndTime]

the only problem i have is that the time displays as

09:00.00 - 09:30.00
10:00.00 - 10:30.00

and i would like them to display as:

09:00 - 09:30
10:00 - 10:30

Try:

Time: Format([tblSchedule].[StartTime], "hh:nn") & " - " &
Format([tblSchedule].[EndTime], "hh:nn")

You're not limited to the named formats, there are lots of options!

John W. Vinson[MVP]