Printing based on contents of a portion of a field

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

Guest

I am dealing with sermons. If the sermons are part of a series, they have a
unique series code. ("PS2" for instance). For the sermons which are not
part of a series, I want to have a miscellaneous series code and group them
together by the way they are stored. I was thinking of adding "-M" to the
code to denote miscellaneous, "IS-M", for example.

I do not want to print the field "sequence number" if the field "series
code" contains "-M".

How can I do this? Am I missing a better way to handle this problem?

Thank you.
C-squared
 
I figured it out using: IIf(InStr(([Series Code]),"-M")>0),"","#" &
Trim([Sequence])))) in the properties/control source for the print field.
 
Back
Top