Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support
MS Access report question MS Access report question
Register FAQ Members List Social Groups Rules Calendar Search Today's Posts Mark Forums Read

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 12-25-2011, 03:02 AM   #1
Member (7 bit)
 
Join Date: Aug 2005
Posts: 119
MS Access report question
Happy Holidays / Merry Christmas to all

I have an MS access report which has 4 currency type fields in its detail section.The fields are calculated inside the query upon the report is based on
Is there an easy way to print a dash ( "-" ) whenever the field is zero (instead of typing the number 0 ,) and in any other case to print the number ?

Thanks in advance

edit : I will have a sum field for each one of the currency filelds at the end of the report
Last edited by johngav; 12-25-2011 at 03:15 AM. Reason: extra information
johngav is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -5. The time now is 09:51 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2

PCMech - Archive - Top