Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Thursday, December 11, 2008 – Permalink –
Alphabetize by One Field or the Other
If one is missing, use the other
Let's say you have a database that has the company name and a contacts name.
In some cases the CompanyName field is empty. If that happens, you want to continue the alpha sort using the contact's LastName.
To do this, you need to create an extra query field to provide the sort, using the NZ() function to replace the contents of one field for null values in another.
<Doug Klippert@ 3:47 AM
Comments: Post a Comment