I have a report that counts a number of records with a grand total. I get this funny slash after the total. If the number is more than 100, e.g., 135, the slash is represented as "13/5"
Any idea what's going on and how to fix?
Thanks!
Novice
Windows 10 
Access 2016
I have a report that counts a number of records with a grand total. I get this funny slash after the total. If the number is more than 100, e.g., 135, the slash is represented as "13/5"
Any idea what's going on and how to fix?
Thanks!
VIP
Windows 7 32bit Access 2007
How is that value being calculated?
Is there any custom format being applied to that field?
Can you post the calculation?
Novice
Windows 10 Access 2016
Nothing custom...here's a screen shot.Originally Posted by JoeM
VIP
Windows 10 Access 2010 32bit
Cannot replicate this. If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 7 32bit Access 2007
If you click on the Properties of that calculated field, what do you have the "Format" property set to?
The "AT" sign "@" is showing up in Format and I didn't put it there
Need a total count of "Yes" entries for records within a specified date range.
Posting Permissions
Reply With Quote