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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/