AW: [AccessD] A2002 Query Question

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



More information about the AccessD mailing list