[AccessD] [SPAM SUSPECT] Nz for Fields

Why not try something like:

WR: iif(not isnull([WorkOrder]),[WorkOrder] & Chr(13) & Chr(10) &
[WorkRequest],[WorkRequest])

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Tuesday, August 01, 2006 10:03 AM
To: accessd at databaseadvisors.com
Subject: [SPAM SUSPECT] [AccessD] Nz for Fields
Importance: Low


I have a report that combines two fields (work order & work request).
They may enter data into both fields or just one. When the report prints
it shows the WO/WR:

 

WR: [WorkOrder] & Chr(13) & Chr(10) & [WorkRequest]

 

I have seen the use of nz to determine if the field is null & that way
it won't put in the return if there isn't a WorkOrder number entered.
The way I have it, if they enter a WorkRequest and not a WorkOrder, it
leaves a blank line above the WorkRequest number.

 

Virginia