Query to select records

[Hugo]

Hi, I have a data base with Customer records, some of them have a bill to address and a ship to address and some have only a bill to address. How can I do to create a query that would select "Ship to addresses only (if both exist) and bill to address (if there is not a ship to address)

Thank you in advance

 

[Pat Hartman]

Select ..., IIf(IsNull(ShipToAddr), BillToAddr, ShipToAddr) As Addr, IIf(IsNull(ShipToCity), BillToCity, ShipToCity) As City, ....