does anyone know how to remove my decimal places in access 2007 query. I'm looking in my Shelly-Cashman book in chapter 2 lab 1 step 8 i cannot find this answer anywhere in the book.
Novice
Windows 7 
Access 2007
does anyone know how to remove my decimal places in access 2007 query. I'm looking in my Shelly-Cashman book in chapter 2 lab 1 step 8 i cannot find this answer anywhere in the book.
Access VBA Developers
Windows XP Access 2003
In the property for that column try formatting as a General Number.
If that doesn't work force it on the actual field like this:
Format ([Field Name] "General Number")
Access Developer
Windows 7 Access 2010 (version 14.0)
You can also set the format in the query design grid.
Will Access 2003 or 2007 work on a pc with access 2000?
Problems opening Access MDB file with Access 2007.
Posting Permissions
Reply With Quote