Or simply use =NZ([DebbieDate],"Unknown")
As the source for the textbox. Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 4:21 PM To: [email protected] Subject: Re: [AccessDevelopers] Re: Reporting Dates Iif([DebbieDate] Is Null, "Unknown",[DebbieDate]) Hal McGee Engineering Data Manager Group Engineering - Process and Compliance Seating Products Group B/E Aerospace Winston-Salem, NC "bassfolks" <[EMAIL PROTECTED] om> To Sent by: [email protected] AccessDevelopers@ cc yahoogroups.com Subject [AccessDevelopers] Re: Reporting 10/25/2005 04:16 Dates PM Please respond to AccessDevelopers@ yahoogroups.com 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 > > > Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access Microsoft access help Microsoft access developer database Microsoft access Microsoft access Microsoft access training training course programming 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. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ 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/
