Thanks alot, it worked it was the IIf command that I had to use. But instead of the comma's "," I had to use ";"
Maybe because of Access 2000? Anyway thanks alot.
Hello,
This seems like a simple problem but I can't find the solution.
I have a database with projectrelations, most of them have a PO box.
When there is no PO box there is a street address.
The problem is that I want to have a query in which it displays the PO box (if available or else the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.