Debbie,
I support Hal's solution here.
Put his IIF() statement into the report.
That will maintain the Date field type integrity
in your table, but give you the printed output that you want.
Good Luck
Norman Pearce
IT Training Manager
Ealining Hospital
Developing the foundations for your success
-----Original
Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 25 October 2005 21:21
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
