[AccessD] Nz for Fields

Gustav Brock Gustav at cactus.dk
Tue Aug 1 09:22:25 CDT 2006


Hi Virginia

You don't even need Nz() for that:

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

/gustav

>>> hollisvj at pgdp.usec.com 01-08-2006 16:02:45 >>>
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