[AccessD] Number format question

John Clark John.Clark at niagaracounty.com
Thu May 13 10:38:14 CDT 2010


Man, this seems like it should be so easy, but I'm missing something...
 
I'm dong this calculation in my program...depending on how many credit hours a student takes, they have an "FTE" value, which is [CredHrs]/30. When this first came to me, these numbers were all in a table, and I was told they were arbitrary, until I discovered that this calculation actually existed. At first I did a DLOOKUP,  based on the credit hours, but I had issues w/that (subform issues), so it was obviously much easier to just do the calculation on the form. There is another calculation, which is [ChargbkRate] * [FTE] * ([MonthsCred]/6).
 
The problem is that, because everyone expects the value on the original table, my calcs are coming up slightly off.
 
The example I'll use is this...
 
Chargeback Rate = $2600
Credit Hours = 14
Months Credit (time they've lived in district) is 3
 
So, the FTE should be .47 ...I am getting .46666666
 
This is throwing it all off, and my calc is $607 where it should be...w/the correct FTE...$611. I'm also thinking, I'll have more problems if the month is something like 2, which would be .3334, instead of the easy .5 that 3 month presents.
 
So, my question is this...how can I dictate that a number stop at the 2 decimals. It is "double" and I've got 2 decimals already specified.



More information about the AccessD mailing list