Anything above .00 is ok to show decimals - however don't want to show .00. Do I have to use an IIF or can this been done in properties? I'd prefer properties if its an option.
Novice
Windows 7 64bit 
Access 2007
Anything above .00 is ok to show decimals - however don't want to show .00. Do I have to use an IIF or can this been done in properties? I'd prefer properties if its an option.
Advanced Beginner
Windows 7 64bit Access 2010 64bit
surly you can use property and in format tab put 0 in decimal places. Ithink it's working fine.
query to show "missing data" like excel pivot table?
Fields do not show in "Form View"
Posting Permissions
Reply With Quote