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