Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2015, 03:28 AM
nellolopez nellolopez is offline Help with Crosstab report Windows 7 32bit Help with Crosstab report Office 2010 32bit
Novice
Help with Crosstab report
 
Join Date: Feb 2015
Posts: 2
nellolopez is on a distinguished road
Default Help with Crosstab report


I can't figure out why my crosstab report is showing two decimal places. I already set Options to 0 digits. I want whole numbers. Thank you!
Attached Files
File Type: pdf Crosstab-Toolbox.pdf (44.8 KB, 7 views)
Reply With Quote
  #2  
Old 05-22-2015, 07:27 AM
JulieS JulieS is offline Help with Crosstab report Windows 7 64bit Help with Crosstab report Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm guessing you are showing Work values in the cross tab, not money. The setting for decimals places applies to money, not work.
Reply With Quote
  #3  
Old 05-22-2015, 10:54 AM
nellolopez nellolopez is offline Help with Crosstab report Windows 7 32bit Help with Crosstab report Office 2010 32bit
Novice
Help with Crosstab report
 
Join Date: Feb 2015
Posts: 2
nellolopez is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
I'm guessing you are showing Work values in the cross tab, not money. The setting for decimals places applies to money, not work.
Thanks JulieS for the quick reply. You're correct, it's values (peak units). How do I fix it so the report will show whole numbers? I'm not on my computer now; but I will check as soon I get on my PC.
Reply With Quote
  #4  
Old 05-26-2015, 07:17 AM
JulieS JulieS is offline Help with Crosstab report Windows 7 64bit Help with Crosstab report Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The peak units field usually only shows whole numbers expressed as percentage. Are you sure your report is using Peak?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Crosstab report help with report and VBA benjaminyap Word 1 01-15-2015 10:40 PM
Help with Crosstab report Copy matching data from one report cell to another cell report mbesspiata Excel 9 01-15-2015 01:49 PM
macros for automatization of crosstab psychologist Excel Programming 0 11-24-2014 03:04 AM
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
Example Report Hinchy Word 0 10-09-2012 07:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft