[AccessD] Fields with Null

How about something like this off the top of my head
Desc: ("COMMENTS: "+If([Comments]is null,"",[Comments]) & (Chr(13) &
Chr(10) & "REMARKS:
"+[Remarks]) & (Chr(13) & Chr(10) & "INV COMMENTS: "+[InvComments])

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,
Virginia
Sent: Friday, February 02, 2007 8:15 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Fields with Null

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

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