Mail to a PO Box when available, default to physical when not.

[fajardok]

OK, the title stinks I know... I have a database with addresses. For the majority of the individuals, the address is also their mailing address.. but for some, there is an additional field if they have a differnt PO BOX.

Is there a way to run a report and/or query that if the 'PO/BOX' field is blank or Null it defaults to the "Physical" address, but if there is information in the PO/BOX field, It would print that on the Mailing Report?

Thinking it might be easier to just export into Excel and Sort... any thougths?

[pbaldy]

Shouldn't be too difficult. If the PO Box field would be Null, this type of thing would work:

Nz(POBoxFieldName, OtherFieldName)

[fajardok]

Thanks... where do i put the code?

Shouldn't be too difficult. If the PO Box field would be Null, this type of thing would work:

Nz(POBoxFieldName, OtherFieldName)

[pbaldy]

Wherever you want the substitution made. Typically in a query or on a form or report, but it can work anywhere.