Stripping Minutes From Hour When Only 00., Access 2010

[jamiers]

My supervisor wants me to create the following expression in a query. I need to merge fields and format to get it done.

Field 1: Date and Start Hour Training
Field 2: End Hour Training

New merged field...output should be something like this
Sa 9a-4p
M 9:30a-4:15p
Th 10:00a-1p

I have created a lookup for the day -- so I am not concerned about that... Look up Saturday, return Sa... look up Monday, return M.

But... what I can't figure out is how to dump the minutes if ONLY equal to 00 (9:00 should come back 9a, and 4:15 should come back as 4:15p).

This what I have going:
TrainingDayTime: [ShortDay] & " " & [TrainingRange]

Short Day is the lookup for the DayCode (Sa, Su, M, Th)
Training Rage field shows this expression: TrainingRange: Format([Start Date/Time],"h:nna/p") & "-" & Format([End Date/Time],"h:nna/p")

What can I do to those nn's to get them to only show if it is minute 01 to 59 and not 00?

[CJ_London]

To clarify,

what you want is

Sa 9a-4p

what you are getting is

Sa 9:00a-4:00p

try

TrainingRange: Format([Start Date/Time],iif(datepart("n",[Start Date/Time])=0,"ha/p","h:na/p")) & "-" & Format([End Date/Time],iif(datepart("n",[End Date/Time])=0,"ha/p","h:na/p"))

If you were happy with Sat rather than Sa, you could add 'ddd' to the start of your format string e.g. "ddd ha/p" which would save you your shortday function