paul.hartland at fsmail.net
paul.hartland at fsmail.net
Thu Jan 4 07:07:22 CST 2007
Just off the top of my head, will this work (in query): Comments:IIF(IsNull([DescRequest]),"",[DescRequest] & vbcrlf) & IIF(IsNull([Evaluation]),"",[Evaluation] & vbcrlf) & IIF(IsNull([Justification]),"",[Justification]) Paul Message Received: Jan 04 2007, 12:58 PM From: "Hollis, Virginia" To: accessD at databaseadvisors.com Cc: Subject: [AccessD] Join 3 Fields 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Paul Hartland paul.hartland at fsmail.net 07730 523179