[AccessD] Join 3 Fields

Hi Virginia

That could be:

=("Description: " + [DescRequest]) & (Chr(13) & Chr(10) & "Evaluation: " + [Evaluation])  & (Chr(13) & Chr(10) & "Justification: " + [Justification])

This assumes that Description is never Null.
Note the use of + to set the complete line to Null if the field is Null.

/gustav

>>> hollisvj at pgdp.usec.com 04-01-2007 13:57 >>>
I need to join three fields, the Description of the request, Evaluation,
and Justification to show as one on a report. I used the below in a
query, but what I need is to show a break between the fields. Or even if
somehow I could put the words Description or Justification before each
paragraph.

 

Comments: [DescRequest] & IIf(([DescRequest] Is Null Or [Evaluation] Is
Null Or [Justification] Is Null),Null,Chr(13) & Chr(10)) &
[Justification]

 

 

Like this:

Description: Description blah blah.

 

Evaluation: This is the evaluation part of this.

 

Justification: Ok now the justification below all that.

 

Not this:

Description blah blah.This is the evaluation part of this.Ok now the
justification below all that.

 

Virginia