[AccessD] Nz for Fields

Hollis, Virginia hollisvj at pgdp.usec.com
Tue Aug 1 09:02:45 CDT 2006


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




More information about the AccessD mailing list