[AccessD] Gaps in Address Query

Thanks for everyone's help (Yet Again), works 100% now.....

Paul Hartland


From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
Date: Tue 15/Apr/2003 12:47 GMT
To: accessd at databaseadvisors.com,  <paul.hartland at fsmail.net>, 
   accessd at databaseadvisors.com
Subject: Re: [AccessD] Gaps in Address Query

On 15 Apr 2003 at 22:40, Stuart McLachlan wrote:

> 
> Try IIf(NZ([addrs1],"") = ,"",[addrs1]+Chr(13)+Chr(10))
> 

Oops, missed a set of quotes:

Try IIf(NZ([addrs1],"") = "" ,"",[addrs1]+Chr(13)+Chr(10))

-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.