RE: [AccessDevelopers] Reporting Dates

[Pearce, Norman]

Debbie, the fact that you sort on this field, you should not put a "Text" entry stating Unknown. You have designed it as a date field, so data entry must remain in a Date format.   What you could do, is to set a default entry say "01/01/1900", which would at least block everything together and make it obvious that the date is not valid, but would that then have repercussions on reports etc.   My personal feeling is that you should leave it blank.   Regards   Norman Pearce IT Training Manager Ealing Hospital Developing the foundations for your success   -----Original Message----- From: bassfolks [mailto:[EMAIL PROTECTED] Sent: 24 October 2005 17:02 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Reporting Dates   We have a date field which is not required to be filled in because sometimes the date is not provided.  In those instances we leave the date blank because we may come across a document in our review which provides the date. We would like to reflect those blank dates as "unknown" in our reports rather than having nothing.  We do sort on the date field quite frequently.  How do we do it? Thanks! Debbie Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.