Iif function not returning any true values

[lindseyaileen]

I am trying to create a report that automatically create my spring and fall contracts. I label each semester with a S for Spring and F for fall followed by the the two digit year (ex S15 for Spring 2015). In the table this is a text column.

I am trying to make it so that it if Semester has an S in it the title of the contract will say Spring/Summer YYYY. I've also tried to do this with dates but I haven't found a solution that let me do it by month.

Inside the expression builder I have this written:

<code>IIf([Semester]="S*","Spring/Summer " & Year([StartDate]),"Fall " & Year([StartDate]))<code>

It only ever gives me the false value. Any help would be much appreciated. I'm sure there is a super easy fix that I'm just not seeing.


Also, as a side note: if anyone knows how to make access list every Wednesday's date between a start and end date I would also find that super helpful. (ex. Every Wednesday between now and April 20th would be: 3/18, 3/25, 4/1, 4/8, & 4/15) I haven't been able to find this anywhere and I'm not even sure this is possible.</code></code>

 

[Joe4]

Try:

[COLOR=#333333][FONT=monospace]IIf(Left([Semester],1)="S","Spring/Summer " & Year([StartDate]),"Fall " & Year([StartDate]))[/FONT][/COLOR]

 

[lindseyaileen]

Brilliant! Thank you! I stared at that for hours this morning.