Unanswered: Mailing list query to consider 2 addresses
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.