Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Mailing list query to consider 2 addresses

    Hi all...

    Any help would be great. Microsoft Access 2003. I have a contacts list table with options for 2 contact addresses per record. There is an option group field which asks users which address to post to, home/work. I am building the report to run from a query, but am having trouble.

    In the query i have the name field and mail to (option group) field. My criteria for the mail to is:

    Expr1: IIf([MailTo]=1,[Home Address]) Or IIf([MailTo]=2,[Work Address])

    But its not returning the right results.. Still seems to be feeding back the home addresses.

    Little help?

    Thanks all.

  2. #2
    Join Date
    Mar 2006
    Try this.
    Expr1: IIf([MailTo]=1,[Home Address],[Work Address])

  3. #3
    Join Date
    May 2006


    Fantastic, not sure what was stopping that working before.. but its up and running now... thanks Norie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts