How do I get the report to display the ship address if the mail a.

[Guest]

I want the shipping address to display if the mail address is a PO Box. I'm
not sure if this is for the query or report environment. Could use some
tips. Thanks.

 

[Guest]

I would place a criteria in the query by using an If, Then statement. On the
Criteria line of the query in design view, right click and choose Build, the
Expression Builder will appear and then in the left lower box you want to
choose Functions, then Built In Functions. Search on the right for the If
statement. It will guide you on how to use the proper sintax. On that right
side you will be able to select your query and select the fields you are
wanting to compare. The logic would be something like this: If the mail
address does not equal (<>) a PO Box, then select the shipping address. I
don't know how familiar you are with building expressions but you will have
to give the expression a name and then create the formula.

I hope this makes sense.

 

[John Spencer (MVP)]

How do you know the mail address is a PO Box? Is there a field that you check
or do you just look for "PO Box" Or "P.O. Box" or "P. O. Box" at the beginning
of the mail address?

You could try the following in your query.

Field: PrintAddress: IIF(MailAddress Like "PO Box*",MailAddress,ShippingAddress)