Hollis, Virginia
hollisvj at pgdp.usec.com
Fri Feb 2 08:15:01 CST 2007
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