I admit to not being the brightest bulb in the box but I cannot make this work. What I want is for the report to print out with the word Unknown in the date field if it is empty in the table.
Talk to me like I have no idea what I'm doing and maybe I can get it. :) Debbie --- In [email protected], "Databasedude.com" <[EMAIL PROTECTED]> wrote: > > Let's say your date field is named DebbieDate. You can show it in > queries as "Unknown" when blank, as follows: > > SELECT Nz([DebbieDate],'Unknown') FROM tablename > > HTH > Bryant > > --- In [email protected], "bassfolks" <[EMAIL PROTECTED]> > wrote: > > > > 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 --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
