Getting rid of the (p) stamp in a report.

[DurkeeM]

I am driving myself insane trying to figure out how to get the start date inside of a report to stop having the (p) stamp at the end of it.

How it's displaying:"Digital Camera Basics," 7(p)-9p.m.Tuesdays, Sep. 8-29. Fee: $89.

How I want it to display: "Digital Camera Basics," 7-9p.m.Tuesdays, Sep. 8-29. Fee: $89.

So far I've changed the start time to "Short Time" and I've been trying to decode the mile long Iif expression, but I've been facing some difficulties.I've pasted it below in case the answer is staring me right in the face.

=Chr(34) & [CourseTitle] & "," & Chr(34) & " " & (IIf(((((Format([StartTime],"Short Time")>="12:00")) And ((Format([EndTime],"Short Time")>="12:00"))) Or (((Format([StartTime],"Short Time")<"12:00")) And ((Format([EndTime],"Short Time")<"12:00")))),IIf((Format([StartTime],"nn")>0),(Format([StartTime],"h:nn”)),(Format([StartTime],"h "))) & Chr(45) & IIf((Format([EndTime],"nn")>0),(Format([EndTime],"h:nn a/p") & ".m."),(Format([EndTime],"ha/p") & ".m.")),IIf((Format([StartTime],"nn")>0),(Format([StartTime],"h:nn ")),(Format([StartTime],"h”)) & Chr(45) & IIf((Format([EndTime],"nn")>0),(Format([EndTime],"h:nna/p") & ".m."),(Format([EndTime],"ha/p") & ".m.")))) & IIf([StartDate]=[EndDate],Format([StartDate],"dddd"", ""mmm"". ""d"),IIf([StartDate]<>[EndDate] And Format([StartDate],"mmm")=Format([EndDate],"mmm"),Format([StartDate],"dddd""s, ""mmm"". ""d") & Chr(45) & Format([EndDate],"d"),IIf([StartDate]<>[EndDate] And Format([StartDate],"mmm")<>Format([EndDate],"mmm"),Format([StartDate],"dddd""s, ""mmm"". ""d") & Chr(45) & Format([EndDate],"mmm"". ""d"),""))) & ". Fee: $" & [ClassFee] & "."

Any help is extremely welcome!

[ranman256]

format([date],"hh")

[CJ_London]

really can't work out exactly what you require

are the options?
9-10am
5-6pm
11am-2pm

and if so why not
9am-10am
etc?


e.g. format(starttime,"ham/pm") & "-" & format(endtime,"ham/pm")

[DurkeeM]

Where in the expression would I slip this into?

[DurkeeM]

The report needs to be generated in a specific way to meet the criteria of who we're sending it to. So the only option for listing time is 7-9:30p.m. and not 7p.m.-9p.m.

[CJ_London]

OK so you are back to your iif statement.

Before I spend more time on this, please clarify what are all are the options regarding the times that could be displayed

9-10a.m.
5-6p.m.
11a.m.-2p.m.

are these all of them? if no what others are there?

are any of the above not relevant (e.g. you don't have appointments spanning midday)

[June7]

I copy/pasted the IIf expression into Notepad++. It shows the first ( in front of the first IIf() is unmatched. It also shows the ( that follows is unmatched. Lots of unnecessary () pairs.

Notepad++ is a free download.

I did a Replace operation on the expression in VBA. 63 '(' were replaced but only 62 ')'. So it seems there is not only an extra ( but also a misplaced ( or ).

Consider this simpler format:

Format([StartDate],"dddd\s, mmm. d")