Time Format in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
TeeInformation: "Group " & [Group] & " - " & [Course] & " - " &
Format([TeeTime],"Short Time")
 
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...
 
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...
 
Back
Top