IIf statements

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
I'm trying to write an IIf statement to produce mailing labels.
What I'm trying to do is:
If the teaching position is Principal then the letter is sent to the
directors address, otherwise the letter is sent to the Principal at the
school but this needs to be the school mailing address (or if that is null)
the school address.

This is what I have so far: (this part is just to print the correct mailing
address)
Letter Address: IIf([NSW Applications]![TEACHPOS]="PRIN",[Supt
Listing]![ADDRESS] & "
" & [CITY] & " NSW " & [POSTCODE],IIf(IsNULL[NSW Applications]![MSCHLADD],
[SCHLADD] & "
" & [SCHLCITY] & " NSW " & [SCHLPCODE],[MSCHLADD] & "
" & [MSCHLCITY] & " " & [MSCHLSTATE] & " " & [MSCHLPCODE]))

Any advice would be greatly appreciated
.

Relevant Pages

  • Re: school supplies!
    ... I'm confused too, the call in April was because I was attempting to make sure my kids did get their physicals around a year after the last one, you'd think calling 9 months after the last one would make that likely! ... The timing of the appointment was nothing to do with us not being able to make appointment we were offered, we turned down a couple of times, but they would have been less than a week earlier. ... So calling and finding out that even this was not possible was rather stressful, given the letter said it was essential to have it returned by the first day of school - so I called the school and they told me not to worry just bring it in after the appointment we already had scheduled, so the whole process created much unnecessary stress, which wouldn't have happened had I got the form sooner - we had had a mailing of paperwork about 2 months ago with things like immunisation form in it and every other thing you could think of. ...
    (misc.kids)
  • Re: IIf statements
    ... re-doing it again in the builder. ... "Jeff Boyce" wrote: ... I'm trying to write an IIf statement to produce mailing labels. ... school but this needs to be the school mailing address (or if that is ...
    (microsoft.public.access.gettingstarted)
  • Re: [Full-disclosure] ureleet
    ... you're like the school boy bully who never grew up. ... you and valdis is ... like a tag team, sad lonely people who just annoy people on mailing ...
    (Full-Disclosure)
  • Re: IIf statements
    ... I'm trying to write an IIf statement to produce mailing labels. ... school but this needs to be the school mailing address (or if that is ...
    (microsoft.public.access.gettingstarted)
  • Re: Annoying players (was Re: Resource Poaching)
    ... Yeeeeeaaaaars ago a friend was sending out letters of application ... for a teaching position. ... She showed me the letter before mailing it out, ...
    (alt.games.warcraft)