Put that
statement in the query on which the report is based. [DebbieDate] is the
name of your date field.
-----Original Message-----I admit to not being the brightest bulb in the box but I cannot make
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bassfolks
Sent: Tuesday, October 25, 2005 15:16
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Re: Reporting Dates
Importance: Low
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 AccessDevelopers@yahoogroups.com, "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 AccessDevelopers@yahoogroups.com, "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 developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access 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.
