Search results

This is probably an easy question, but I can't figure out how to get a table to show numbers in 2 decimals points when they are inputted with 2-5 decimal points. I changed the DATA TYPE to Number and DECIMAL PLACES to 2, but when I do that, it just rounds it to a whole number. Please help, thanks!

Hi, I am a longtime Excel user, and am now migrating some work to Access. I have 2 fields dealing with dates in the format mm/dd/yyyy hh:mm, OPEN and CLOSE I'd like to get the difference between the two in hours, but I have no idea how or where to do this in Access. I'm assuming it is put...