Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2005

Tip: Looking for answers? Try searching our database.

Don't want to see zero

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pas926 - 20 Jan 2005 01:37 GMT
I'm using Word 2000 and merging from a query in Access 2000.  I don't want to
see anything if the result is zero.  When I use the if then statement I get
"Supervisor hours 2" but if it's zero I will see "0"  I want to suppress the
zero.  Any help is appreciated.   Thanks in advance Paul
Doug Robbins - 20 Jan 2005 01:49 GMT
It would be easier to help if you had provided the field construction that
you are using, but I would always do this with a query in Access that used
the IIF function returning "" if the field being tested contains 0.

In Word, you would use the same "" as the result to be displayed if your
If...then...else field detected a zero value.

--
Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
> I'm using Word 2000 and merging from a query in Access 2000.  I don't want
> to
[quoted text clipped - 3 lines]
> the
> zero.  Any help is appreciated.   Thanks in advance Paul
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.