[AccessD] Fields with Null

Mmm, doesn't do that for me. Are you sure the Comments field is null? Could
it have blank spaces in it somehow? Add this to your query:

TestNull: IsNull([Comments])

Do the "empty" Comments records return -1 (ie True)?

--
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] Fields with Null
Date: 02/02/07 15:04


Yes, it is for reports. This works, but same as Chesters - It shows the
COMMENTS in each field even if there aren't any comments. It doesn't do
that for the REMARKS or INV COMMENTS.

*******************
Aah you're using this in SQL aren't you, not code. Vbcrlf is VBA so
code-only. Ok, so going back to the chr(13) & chr(10) try:

("COMMENTS: "+[Comments]+(Chr(13) & Chr(10))) & ("REMARKS:
"+[Remarks]+(Chr(13) & Chr(10))) & ("INV COMMENTS: "+[InvComments])

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



--
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