Hello Debbie If you want to state 'unknown' in the report for a blank date field, use the IIf function in the control source of the date field.
Ex. if the date field is called rptDTE, write: =IIF(IsNull ([rptDTE]),"",[rptDTE]) or if you know the empty date field is returning an empty string "", then write: =IIF([rptDTE]="","",[rptDTE]) hope this helps Gregory ----- Original Message ----- From: "Pearce, Norman" <[EMAIL PROTECTED]> To: "'[email protected]'" <[email protected]> Sent: Tue, 25 Oct 2005 10:15:40 +0100 Subject: RE: [AccessDevelopers] Reporting Dates > 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: [email protected] > 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. > > > > > SPONSORED LINKS > > > Microsoft access developer > > Microsoft access help > > Microsoft access database > > > Microsoft access training > > Microsoft access training course > > Microsoft access programming > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of Service. > > > > _____ ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
