Time Format in a Query

T

TinleyParkILGal

I have a concatenation which contains the following:
TeeInformation: "Group " & [Group] & " - " & [Course] & " - " & [TeeTime]

In my query, what is displayed for this field is:
Group 1 - North Course - 11:10:00 a.m.

How do I format this field in my query to eliminate the long time?

Thanks in advance.
 
D

Duane Hookom

TeeInformation: "Group " & [Group] & " - " & [Course] & " - " &
Format([TeeTime],"Short Time")
 
T

TinleyParkILGal

This works, thank you, however, it drops the am/pm.

Duane Hookom said:
TeeInformation: "Group " & [Group] & " - " & [Course] & " - " &
Format([TeeTime],"Short Time")

--
Duane Hookom
MS Access MVP



TinleyParkILGal said:
I have a concatenation which contains the following:
TeeInformation: "Group " & [Group] & " - " & [Course] & " - " & [TeeTime]

In my query, what is displayed for this field is:
Group 1 - North Course - 11:10:00 a.m.

How do I format this field in my query to eliminate the long time?

Thanks in advance.
Click to expand...
Click to expand...
 
T

TinleyParkILGal

Opps, apologies, I changed short time to medium time and it worked perfectly!!
Thank you Duane Hookom.

Duane Hookom said:
TeeInformation: "Group " & [Group] & " - " & [Course] & " - " &
Format([TeeTime],"Short Time")

--
Duane Hookom
MS Access MVP



TinleyParkILGal said:
I have a concatenation which contains the following:
TeeInformation: "Group " & [Group] & " - " & [Course] & " - " & [TeeTime]

In my query, what is displayed for this field is:
Group 1 - North Course - 11:10:00 a.m.

How do I format this field in my query to eliminate the long time?

Thanks in advance.
Click to expand...
Click to expand...
 
Top