Michael Brösdorf
michael.broesdorf at web.de
Fri Apr 11 07:09:31 CDT 2003
How about Name & chr(13) & (Add1+chr(13)) & (Add2 + chr(13)) etc. (If you use + to concatenate strings, the result of strMyString + NULL will be NULL, whereas using & would return strMyString) HTH, Michael -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von paul.hartland at fsmail.net Gesendet: Freitag, 11. April 2003 12:17 An: accessd at databaseadvisors.com Betreff: [AccessD] A2002 Query Question To all, I have a query which displays the address of a job and the number of people allocated like so Name Add1 Add2 Town County PCode Staff B&Q 6 Somewhere Close Anywhere Everywhere ZZ86 7DY 53 How I actually want it to display is : Store Staff B&Q 53 6 Somewhere Close Anywhere Everywhere ZZ 86 7DY so the address appears as above and with any blank lines removed I tried something similar to the following : Store : Name & chr(13) & iif(Isnull(Add1),"",Add1 & chr(13)) & iif(Isnull(Add2),"",Add2 & chr(13)) etc but I then get each line of the address seperated by a control character, I'm sure I have used something similar before, but can't seem to find the code I used. Anyone any ideas on how to achieve this..... Thanks in advance.... Paul __________________________________________________________________________ Join Freeserve http://www.freeserve.com/time/ Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com