[AccessD] Nz for Fields

Hi Virginia

Try this

WR: ([WorkOrder] + vbcrlf) & [WorkRequest]


--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
Subject: [AccessD] Nz for Fields
Date: 01/08/06 14:04


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

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

________________________________________________
Message sent using UebiMiau 2.7.2