Competent Performer
Windows 7 64bit 
Access 2007
I do not allow Null values in my database. I was just wondering if there is a "Null Alternative" for a Date/Time field. I would rather not populate each record with a dummy value like 12/31/9999. Is there anything else I could use. Would the Nz() function work?
VIP
Windows XP Access 2010 32bit
In a query:
Nz(datefield,#12/31/9999#)
Exactly what is the issue with null value in date field? What is it interfering with?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Getting Just the Date part of Date/Time field
Passing a NULL value to a date field
Is Not Null With Variant Variable Assigned To Date Field
Posting Permissions
Reply With Quote