> Ok, if you NZ() you can shove a value in for the null in access. Took 5 > different MVPs before the sixth came in with that little trick.
I'm guessing this is a VB 'feature' and not specific to Access (Verity Stob has a nice diatribe about the inconsistencies of Basic - well worth googling for) - for example PL/SQL and VFP use nvl(var, varIfNull) - just to prove it's different T-SQL has isnull(var, varIfNull), VB and VFP have isnull(var) which returns True or False (VB explains the need for this funtion with the magnificently False statement "because any expression containing a Null is itself Null and, therefore, False" and it seems VB has nz(var [,varIfNull]) - which I must admit was news to me as well! Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
