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.
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.
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")
You can also set the format in the query design grid.