[AccessD] Fields with Null

Hi Virginia, try

Desc: "COMMENTS: " + [Comments] + vbcrlf) & "REMARKS:
" + [Remarks] & vbcrlf) & "INV COMMENTS: " + [InvComments]

(I prefer the vbcrlf to chr(13) & chr(10) but they do the same)

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessD at databaseadvisors.com" <accessD at databaseadvisors.com>
Subject: [AccessD] Fields with Null
Date: 02/02/07 14:16


I am using the below in a query to join 3 field into one. Each field is
designated by the description. My problem is I need to check for null
fields. The way I have it now, if Comments are null and Remarks has text
in it, it leaves a line & starts Remarks in the middle of the field. I
need an Iff Null somewhere.



Ex:

COMMENTS: this is the comments

REMARKS: remarks go here

INV COMMENTS: Other comments



What it is doing:



REMARKS: remarks go here

INV COMMENTS: Other comments



Desc: ("COMMENTS: "+[Comments]) & (Chr(13) & Chr(10) & "REMARKS:
"+[Remarks]) & (Chr(13) & Chr(10) & "INV COMMENTS: "+[InvComments])



Virginia


________________________________________________
Message sent using UebiMiau 2.7.2