By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,475 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,475 IT Pros & Developers. It's quick & easy.

Why these divisions are not the same

P: 14
How could I make

Me.Hours = Me.Minutes / 60 to be the same as [Minutes]/60.

Me.Hours = Me.Minutes / 60 doesn't give the correct hour.
If I have 66 minutes, it only gives me 1 hour. But with [Minutes]/60, I get 1.1 hour

Michelle
Dec 11 '06 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
How could I make

Me.Hours = Me.Minutes / 60 to be the same as [Minutes]/60.

Me.Hours = Me.Minutes / 60 doesn't give the correct hour.
If I have 66 minutes, it only gives me 1 hour. But with [Minutes]/60, I get 1.1 hour

Michelle
Michelle

You need to change the data type of hours from Integer/Long Integer to Decimal or Single.

Mary
Dec 11 '06 #2

P: 14
Hi Mary,

Where can I change the data type to single or decimal. The table does not have the option to change the data type to Single or decimal.

Michelle
Dec 11 '06 #3

P: 14
Thanks Mary, it works . Michelle
Dec 11 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks Mary, it works . Michelle
You're welcome Michelle

Mary
Dec 11 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.