[AccessD] Gaps in Address Query

Stuart McLachlan stuart at lexacorp.com.pg
Tue Apr 15 07:47:22 CDT 2003


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.





More information about the AccessD mailing list