Recent content by hockeyroom28

How, sorry I have no idea?

It was DOUBLE, but I don't know which one will hold Decimal. I tried Decimal, but it rounded to a whole number

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!

Bump please... I'm trying to take the results from Expr1: (DateDiff("n",[Open],[Close],"0.00")/60) in a query and try to have them rounded to 2 decimal places.

Thanks again Rainman. It's close I think... Here is what I have: Expr1: (DateDiff("n",[Open],[Close],"0.00")/60) The original result on Excel was 42.4875 and the result on Access is 42.4833333 and another entry is 4.75 (original was 4.759722222). Any idea? Thanks!

Thanks for the reply, but this only changes the result from: 42 to 42.00 I think it might be only counting hours, so is there a way to get it for minutes? "m" doesn't work in place of "h". Any ideas? Thanks!

I tried the following expression in a query =DateDiff("h",[Open],[Close]) It got the result I wanted, but it only showed as a 2 digit #, leaving out the decimal. Is there anyway to include those? Thanks again!

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...