Thanks for help in advance. I am trying to write a query which would look like this....LASTNAME, firstname & secondname. However, if the secondname is blank I only want LASTNAME, firstname to show. I've tried using the build and all kinds of things but had no luck. when I run the query it pulls up a parameter box asking for secondname. Please help.
Last edited: