[AccessD] [SPAM SUSPECT] Re: Nz for Fields

Good one Gustav.  I always forget about that one.

Bobby

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


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