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: AccessDevelopers@yahoogroups.com
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 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 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.
------------------------ 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/
